Discussions

Filter by security groups

Is it feasible to use the security group name to filter the data set (row level)?

SQL Database Built in Functions

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...

Sum of 3 months of Measure to show as quarter value

Hi , I have below requirementIf one customer have revenue for three months like Jan,Feb.Mar(Q1).Jan=100Feb=20Mar=30Sum of Jan +Feb+Mar=150This 150 value show in separate column to show 3 times in the report as below. I want to calculate the Ratio by ...

Failed to get lastCheckpoint file

Following parquet files migration between environments, deleting the schema.table records from FILES_VERSIONS table in metadata db and performing a successful stage load.DELETE from FILES_VERSIONS where NAME like 'Schema_Table.%';Table is failing wit...

Incremental Load query

Hello Community,We have a schema that is currently scheduled with a full load, and I would like to switch to incremental load for specific tables.These tables have a timestamp column (for example: creation_date) that should be used for incremental lo...