To Date

Creates a column of a date/timestamp type from a string or other non-date column.
See this Snowflake doc for information about valid formats.
Parameters
Name
Type
Description
Is Optional
dates
column_value_dict
dict where the values are the date columns and the keys are the date formats to use for the conversion
​
overwrite_columns
boolean
Optional: if true, the output columns will overwrite the input columns
True
Example
ds = rasgo.get.dataset(id)
​
ds2 = ds.to_date(dates={
    'DATE_STRING':'YYYY-MM-DD',
    'DATE2_STR':'YYYY-DD-MM'
  })
ds2.preview()
Source Code
RasgoTransforms/to_date.sql at main · rasgointelligence/RasgoTransforms
GitHub

Name	Type	Description	Is Optional
dates	column_value_dict	dict where the values are the date columns and the keys are the date formats to use for the conversion
overwrite_columns	boolean	Optional: if true, the output columns will overwrite the input columns	True

Timeseries Agg

Train Test Split

Last modified 1yr ago