1 Reply Latest reply on Sep 5, 2018 6:16 AM by Alex Kerin

    Getting data from information.schema (MYSQL) (Solved)

    Alex Kerin

      I'm trying to grab a max datetime from information.schema - I can see information.schema as on the list of dropdown DBs when I add the source. However, no tables pops up to drag over.

        • 1. Re: Getting data from information.schema (MYSQL) (Solved)
          Alex Kerin

          Solved, but leaving here for others..

           

          My understanding of DB's is 'imperfect' shall we say. Information.schema can be accessed from any connection. I created a new custom sql in an existing connection and a fake column to join with my other tables:

           

          SELECT 1 as User_ID, max(create_time) as Update_Datetime FROM  information_schema.tables

           

          Works fine (as long as you have a User_ID of 1 in your joining table)