I have a date table in a Microsoft Fabric Data Warehouse. This table contains 3 columns: year, quarter, and period, where the last one has a format 'YYYY/QUARTER'. This table will be linked in the model to another sales table which also has a period column with the same structure as the date table. I would like to know if it's possible that when I add data to the sales table, the dates in the date table are automatically populated based on this new data that was added in the sales table. I tried to create a trigger but I'm getting the error: 'CREATE/ALTER TRIGGER is not supported.' Could you help me with this?
Trigger in Microsoft Fabric Data Warehouse
103 views Asked by André Lourenço At
1
There are 1 answers
Related Questions in TRIGGERS
- Delete trigger run for each deleted row when delete multi row on edit tab
- Have a script work multiple times with the same class
- Trigger when viewing a certain sheet in google apps script
- trouble to trigger Jenkins job
- Postgresql Auto Update Column
- PowerAutomate Flow not behaving as intended for SharePoint List Modifications; Issue may be Trigger formulas
- Safely using TRUNCATE with active AFTER INSERT triggers in PostgreSQL?
- While-loop in Python script not working when a record is added in MySQL table from triggers
- Installable Trigger not being installed in published Google Forms Editor Add-On
- Error: pq: at or near "update_assignee_columns_trigger": syntax error: unimplemented: this syntax
- Why does the trigger execution log for a sendEmail function of my google script project says it's completed, and yet no actual emails are being sent?
- SQL Server trigger is blocking data to the table
- Logic app blob trigger retry policy not working for 503 error
- Data Factory triggers two releases on Azure DevOps after Pull Request
- Trying to run a procedure inside After insert trigger , even though procedure run for 10 mins last row updated time is same as 1st row
Related Questions in MICROSOFT-FABRIC
- SQL analytics endpoint and Semantic model not being created in MS Fabric Lakehouse
- Fabric Notebook running into error while using TSfresh for feature extraction
- Fabric Capacity metrics data REST API or alternate ways to pull it
- Sending CSV File from Microsoft Data Factory Lakehouse Environment to External Server via SFTP?
- Connect an on-prem SQL Server Analysis Server Tabular Model with Azure Data Factory
- Reading JSON files and getting the correct data type: InferShema is giving me problems and setting it to false isn't an option
- Updating Fabric warehouse tables through a notebook
- How can I write to my Fabric Lakehouse via external app?
- Latency on Azure SQL Server vs. Fabric Datawarehouse SQL Server
- Trigger in Microsoft Fabric Data Warehouse
- Power bi Admin Portal issue Not able to access admin portal
- Data not showing in power bi report
- Data Warehouse to Power BI Desktop
- How to make a Fabric EventStream customapp EventHub not strip the braces from the payload
- Microsoft Fabric Data Flow
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
There are no triggers. Whatever process you use to load the fact table (stored procedure, or pipeline) should rebuild the date table after the load.
Fabric DW is a big data MPP engine, so doesn't support enforced unique constraints, foreign keys, triggers, etc.
So you have to maintain and enforce these sorts of things in your ETL processes.