Hi My Source table is Big Query Table and Target table is Big Query Table.I have created MV and sent to Data Destination getting below error.Big Query Table DateTime Format is as below. I have written formula forEXT_LAST_UPDATE DATE as COALESCE( to...
We are using a PySpark script inside Incorta to call an API and load data into a Materialized View (full load). Since loading this MV directly into a table is not feasible, we store the data in a history Materialized View (incremental mode) to mainta...
I'm having difficulty finding the documentation on the viable SQL Database Functions. I'm looking to see if it's possible to use any kind of TRIM() function during table definition, and can't seem to find the right page. Please see the attached scree...
Is this expression supposed to work? SO that the count of such "matches" can be aggregated in an insight to report on:case( (addMonths( $currentDate, 18 ) > WPR_test.Lease.Expire_Date), 1, 0)
It would be very convenient to tag each data source with some name to serve as a hint for multi source tables. Otherwise ine is forced to inspect each datasource's method ie sql or code.
