mysql
Discussion List
-
MySQL Join Optimisation - 2 hours, for what should take seconds!!Hi, I have been trying to optimise a MySQL script, which for some reason is taking over 2 hours to … -
Problems with Workbench, ODBC, MySQL and the data specialist examHi I have a problem with taking this exam: https://learndomo.domo.com/learn/course/383/play/1608/da… -
Generate Date Range Column from Two Date ColumnsHi all ! Im trying to generate a date column with a range of dates from two columns: Table I have … -
Using a View as a input dataset to mysql dataflowHi All, I am trying to have (a view) as one of the inputs to the mysql dataflow...But its not being… -
Calculate rank so that the smaller number is higher rankI need to calculate the rank on a metric where the lower value is higher in rank, and the higher va… -
Rolling Average for Each CategoryI have a dataset containing total monthly units by month and by person. I'd like to calculate the …
-
has anyone had any luck creating dynamic columns in mysqlwhat I'm trying to do is for sql to check and see if a column missing, if it is then i want sql to … -
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E… -
Moving Values One Row Down - Conversion RatesHello! Does anyone know how to move the "Stage Count" column down one row (Stage Count 2)… -
Rolling 30 Day Formula in magic ETLHi, I am trying to write the formula above within magic ETL. Column A consists of static values. C…
-
MySQL Protocol Version ErrorI'm trying to connect to a MySQL Account. When I enter in my credentials and CA Cert I get the erro… -
19Get MySQL on latest versionCurrently, Domo's MySQL is on version 5.6, which is approaching end of support. There are also a nu… -
MYSQL - Trouble adding new column via LEFT JOINHello! I am having trouble adding a new column, "Dummy", to my output dataset. Although t…
-
Schema not keeping changes, but no error given - have you run into this?Hello, So I have set up a job using MySQL ODBC - executed, all good. Job T Then set up another job … -
'Incorrect column name' doing a Dynamic PivotHi there! I've been following this tutorial for dynamic pivot and so far it has worked: https://do… -
Problem with SQL for WordCloud ChartHi all! So, I am trying to run SQL code using these instructions https://domohelp.domo.com/hc/en-us… -
MySQL Recursion Performance/Speed IssuesHello! I am looking for suggestions on how to improve the performance of my mysql dataflow. Current… -
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 current… -
Appending an update set to itselfHi, I have a MySQL dataflow that is built from API reports from a vendors application. The idea is… -
access max.date from sql tableHi. I have two input datasets in SQL Magic Transformation. One table called daily the other one est… -
MySQL Connector to Read Only Some Tables in a Database rather than All Tables in a DatabaseWe are using a MySQL connector to load data from our Google Cloud SQL servers into DOMO. From what … -
How do I used a Create / Use / output table using a SQL transform SQL type / CREATE PROCEDURE?I'm trying to just work out the basic syntax / method in DOMO SQL transform of: Create Stored Proce… -
Convert DATETIME (UTC) to specific timezoneHello, Domosapiens! I have an interesting quandry. I have a data flow (using MagicETL - should I be… -
Is it possible to use while/do loops in MySQL in Domo Dataflows?I have data that has varying rows of data for each identifier, from one row to 26. For each identif…
