Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Recursive Table in MV

Hi,I have start date (File Date) and end date in the table and i want to repeat the rows for each day from start date to end date. Is there any way that I can achieve this in MV? Please see screenshot - Appreciate your help in Advance. Thanks.

nikhil_cr_0-1715103795522.png

Resolved! Period Based Incremental Refresh

Hi Team,Can anyone explain how to do period-based Incremental load based on the Ship_Date column(Date format. not timestamp)?In our current ETl tool, we delete the last 3 months(Ship_Date) records from the Data Warehouse table and load the last 3 mon...

how to convert date to string

Hi,I have two columns , one is timestamp and another one is string. I want to join these two columns in spark sql mv.Date_effective column is timestamp with "yyyy-mm-dd hh:mm:ss" format.Period_name column is string with "mm-yy" format. I want write b...

KKR by Rocketeer
  • 1418 Views
  • 3 replies
  • 0 kudos