Connect to data source through SQL Statement

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.