Databricks

sp1 · 01-15-2023

I want to pass yesterday date (In the example 20230115*.csv) in the csv file. Don't know how to create parameter and use it here.CREATE OR REPLACE TEMPORARY VIEW abc_delivery_logUSING CSVOPTIONS ( header="true", delimiter=",", inferSchema="true", pat...

sp1 · 01-16-2023

Thanks for all your replies.I have used widget using date and it's working as expected.Here is the code:drop view if exists inputdate1;create view inputdate1 as select date_format(current_date()-1, 'yyyyMMdd') AS date UNION ALL select date_format(cur...

Databricks

User Stats

User Activity

Pass date value as parameter in Databricks SQL notebook

Re: Pass date value as parameter in Databricks SQL notebook