This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
If you have the historical data produced within the MV, and cannot be reloaded from the source, you can first backup the data using another MV in a full load and modify the MV logic to load from the backup MV with the new column. I assume that you h...
Here are some possible workarounds:1. Use a Range to select multiple values. For example, if you want to allow the user to select multiple periods or dates and the values can be described in a range. We can give two presentation variables, the FR...
You generate the column name dynamically based on the json_key_list, which is populated based on collect(). The spark action collect() could be expensive and I am not sure if it failed when there is no sampling. We need to test with data.
Incorta file based connector supports loading data from a folder. During incremental refresh, new files will be extracted. We don't use the file name but use the file attributes to detect if there are new or updated files.
Creating an alias is similar to using an alias in a SQL. You can create join between two tables using one foreign key. For example, a table has multiple date columns, order date, booking date, shipping date, scheduled delivery date. If you want to c...