Forum Discussion

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. ...

Icon for Community Champion rank

Community Champion

6 years ago

Have you tried this?

SELECT * FROM  etatspasserelles
WHERE Timestamp  >= DATEADD(day,-30, getdate()) 
and   Timestamp  <= getdate()

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
  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.
  - Dylan_Lemasson
    Frequent Visitor
    6 years ago
    Hello v-xicai,
    
    The SQL server example is what I'd like to do but I can't with an azure table source.
    I juste have this panel :
    
    And then :
    
    I don't know where I can add some restriction to avoid loading the entire table.
    
    Best regards,
    Dylan Lemasson