SQL
Discussion List
-
Converting SQL Dataflows to Magic Dataflows – Tips and TricksYou’ve heard us extoling the virtues of converting your old, slow SQL dataflows into quick, efficie… -
53Get MySQL on latest versionCurrently, Domo's MySQL is on version 5.6, which is approaching end of support. There are also a nu… -
Formatting Fiscal Year and Quarter columnsI am trying to format a column that labels 'FY23' and 'Q1' based on a Period date. What would be th… -
Is there a roadmap for updating to MySQL v8?Hi, A client has asked if we will be updating to MySQL v8 soon as we currently only support MySQL …Answered ✓ ameliabentley 26 views 2 comments 0 points Most recent by Anoosha Medarametla SQL DataFlows -
Creating an Artificial downtime for maintenance for only week and work hoursI am trying to calculate downtime within DOMO. The downtime we have currenlty coming from the other…
-
Is there a way to aggregate the output using a FIXED function used in a CASE statement?I'm a MajorDomo in a large retailer, and I'm working to rewrite our TY/LY Beast Modes to calculate … -
Calculate Previous Quarter Start and End DateHello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter … -
3 month moving with current month for a date columnI am trying to calculate a SQL formula for a moving 90 day period based on month. For example what …
-
Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETLHi Guys, Hope all is good. I am using Magic ETL and trying to create a flow replicating the current… -
Dataset query fails when not using a where clauseI'm trying to get all the data from my dataset by executing a simple query: Here's what my code loo… -
Is there a way to run ad-hoc SQL queries against arbitrary PostgreSQL tables?My company is migrating from Mode Analytics to Domo, and I'm trying to understand whether and how I… -
Making a bucket list of defectsI am trying to make a bucket for sentence long defects and put them in a column that is easier to f…
-
Aggregate count function does not work in the denominatorWhen I use the following statement in a card summary, it works properly. But when use it as a value… -
MySQL Connector vs MySQL Partition Connector "Near Realtime" Performance Best Practice?Hi all, I'm currently investigating the best practice for performance connecting with MySQL for a &… -
Calculating hits per minute by timestamp and Parts ranI am trying to calculate a live hits per minute by machine based on total parts ran per the differe…
-
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL ConnectorHey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query … -
Syntax for nullHi all, I am trying to create a formula in ETL that deals with the null values in multiple columns.… -
MySQLFor this question: Join together two DataSets with MySQL using the name, year, and gender columns a… -
Magic ETL HelpHi, I am going through the Data specialist practical test and am running into troubles. Here are my…
-
2MySQL support for federated datasetsI would love to see federated datasets supported as inputs for MySQL dataflows. Many of my customer… -
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.I have a large table showing plant department and their part numbers with the quantity scraped / do…
-
Status tracking for hot boardI am wanting to track a hot board status for part numbers and want to use the status to track throu…
-
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 … -
Is there a better way to perform a variable-length recursive query using MySQL ver. 5.6?I'm looking to perform a recursive query on a data hierarchy with an unknown amount of levels. I've… -
Add Data that has been modified in the last 7 daysI have a snowflake dataset that has a modified date column. I want to merge the data that has been … -
How can I use the MATCH() function with a declared variable string in a MySQL dataflow?I am looking for assistance in determining how to use the value of a string variable to DECLARE a p… -
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…
