Connect to data source through SQL Statement

[Anonymous]

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

[v-jialluo-msft]

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]

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