Forum Discussion

Dylan_Lemasson's avatar
Dylan_Lemasson
Frequent Visitor
6 years ago

Import an Azure table with a date restriction

Hi,

 

Is there a way to import an azure table with a date restriction ?

It's possible with a SQL database and I'd like to do something similar :

I just get a month of data in this case.

 

In azure, if I import a table I get this screen :

I have more than 5Go of data in this table and I'd like to only get the last month because it's not efficient and I don't want to download 5Go each time I modify a request.

I have a timestamp in this table I could use.

 

Is it possible to give some commands before downloading ?

 

Thanks,

Dylan

Need Help

5 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    6 years ago

    Have you tried this?

     

    SELECT * FROM  etatspasserelles
WHERE Timestamp  >= DATEADD(day,-30, getdate()) 
and   Timestamp  <= getdate()
    • Dylan_Lemasson's avatar
      Dylan_Lemasson
      Frequent Visitor
      6 years ago

      Thanks for your reply.

       

      I can't do SQL request since it's an azure table (I guess ?) and I don't know where to enter a command if possible.

       

      Cordialement,

      Dylan

      • v-xicai's avatar
        v-xicai
        Community Support
        6 years ago

        Hi Dylan_Lemasson ,

         

        When you choose Azure SQL database connector to get the Azure data, you can expand the option "Advanced options" to enter into SQL statement.

         

         

        Best Regards,

        Amy

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.