-
Can I alter or replace the connector for a given dataset?
The MySQL SSH connector I had been using stopped being able to connect last week after my network administrator retired the server that I was using as an SSH tunnel. I can still connect to the target database using a direct MySQL connection and would like to alter the connector settings or swap it with a different…
-
Is it possible to batch edit source data?
I have a large dataset that needs some cleaning. We have appended to this dataset daily over several years and some of the data values have drifted over time as users have renamed what are essentially labels for different entities. If this were SQL, I could write an update statement and quickly replace the values in label…
-
best way to replace a subset of data
I have a large historical dataset to which I append records at the end of each day. I have been asked to correct the distribution of values for a small subset of the data over the past nine months. I can use the data repair tool feature to remove all of the data imports for that time, but this would force me to destroy and…
-
How do I change the field type for a column on an existing table?
My company recently released a new version of our online platform and I am mapping its new database fields to my already existing Domo reporting tables. In the previous system we used a simple integer as the primary key for all of our tables. In the new version we have switched to UUID values for many of our tables.…
-
Can you prevent the MySQL connector from locking its source table while syncing?
I have a large table that takes a while to sync over to Domo through the MySQL connector. I currently schedule the sync to occur overnight because a table lock prevents other users from reading the source table. I would like to sync the table on demand during working hours though. Is there a way to instruct the MySQL…
