Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Connect to data source through SQL Statement

Hello,

I am trying  to connect to snowflake data source but through sql statement like below,

 

 

and am getting this,

 

 

 

my sql statement is,

 

select loan_acct_id, loan_current_status, approved_amount, channel, to_date(to_timestamp(funded_on, 'YYYY-MM-DD HH:MI:SS')) as funded_on_ from prod_datalake.datamart.vw_dim_loan_loan_status
where loan_current_status = 'Loan Funded' and channel = 'In Network' and funded_on_ = current_date();

 

What is going on wrong here!!

Please do help!!

 

Thanks,

Dharani

Need Help

2 Replies

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous,

     

    According to your description, your question is that the SQL statement went wrong.

    It may be that there is an error in this part of the statement:

    to_date(to_timestamp(funded_on, 'YYYY-MM-DD HH:MI:SS')) as funded_on_

    You can try:

    select 
loan_acct_id, 
loan_current_status, 
approved_amount, 
channel, 
to_date(funded_on) as funded_on_date
from prod_datalake.datamart.vw_dim_loan_loan_status
where loan_current_status = 'Loan Funded' and channel = 'In Network' and funded_on_date = current_date();

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

       

      This query perfectly works in the snowflake.

      funded_on column is in text with timestamp. I wont be able to use to_date directly on the funded_column