Comments
-
Here is some SQL that will build a sequential list of days for a preset set of years. You can then LEFT JOIN against your data to set the values for each date: WITH years AS ( SELECT 2020 AS year UNION SELECT 2021 AS year UNION SELECT 2023 AS year UNION SELECT 2024 AS year ), months AS ( SELECT 1 AS month UNION SELECT 2 AS…
-
The answer I received from support is that Domo does not have any tools that will allow altering a dataset directly. If there were options to perform an ETL that imports from a dataset, makes changes, and then writes the changes back to the imported dataset, they are no longer available. @GrantSmith suggests an unsupported…
-
@ArborRose Part of the problem may have to do with the underlying architecture of how Domo stores large amounts of data. I suppose that as Domo receives records it immediately shoves them into a read-only state and assigns a batch number to the uploaded data. The data is therefore highly available for reading, but not for…
-
@ellibot Does the data repair mode allow you to replace all of the uploads at once? I can export the entire 10M row dataset to CSV (about 1GB) and I can edit the dataset locally, but I don't see how to upload the cleaned dataset using the 'Replace with CSV' button. Because my dataset has been appended to daily I have a…
-
It turns out that I did not need to manually alter the table that I was importing into. I changed the SQL in my import for the table to pull from the new data source and tried putting the new UUID values directly into the existing integer field. The Domo importer was smart enough to detect that non-integer values were…
