Data & Schema Discussions

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

Filter by security groups

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

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

Incremental loading with MVs

As what we know , incremental load its work by default in all tables , but for MVs i think its should be manually configured, so i want to ask for help (how can i do incremental loading in MVs to be load only new or updated records) ?

How can we trigger ingestion for an individual table within a schema using the API or any other available option?

Hi All,We have a request to trigger ingestion for an individual table on a daily basis. Is there any way to run ingestion at the table level instead of the entire schema?Thank you in advance.