Popular SQL Functions Missing in Domo

user019875
user019875
in Magic ETL

Domo,

 

I saw a post from 5 years ago stating that SQL didn't have CAST or CONVERT. It's now 2020 and:

  • CAST doesn't even show up in the prompts
  • CONVERT does but doesn't work
  • ROUND is not even considered in the prompts.

Please add these and other popular functions ASAP. It's painful these are not in there...Thank you.

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    These functions will actually still work even though they aren't auto-suggested. See the attached screenshot of a preview in a MySQL dataflow. The same will also work in Redshift.

     

     

     

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    These functions will actually still work even though they aren't auto-suggested. See the attached screenshot of a preview in a MySQL dataflow. The same will also work in Redshift.

     

     

     

  • bdavis
    bdavis Contributor

    Incase this helps anyone coming to this thread, as of 2/5/2020 the version of MySQL in Domo appears to be: 5.6.28-76.1-56

     

    Current version of MySQL available to public: 8.0.19

     

    This way you can check what functions may or may not be available.

  • user019875
    user019875

    Perfect - thank you!

Categories