3 Replies Latest reply on Mar 20, 2020 10:29 AM by Ken Flerlage

    Custom Connector and New Custom SQL

    Dylan Murphy

      Hello,

       

      I've created a new custom connector based on our jdbc driver and the postgresql dialect. I'm able to connect to our database, but I'm not seeing the table information. I thought I'd try to pull some data in through the New Custom SQL option, but our database doesn't support spaces in the name of a table or alias. When you try to create the new custom sql, it issues the statement below to the db.

       

      Does anyone know how to change the name of the alias before it's issued or change tableau's use of spaces to _?  For example, this would be fine for us if it was Custom_SQL_Query

       

      [2020-03-20T16:16:48.238481][DEBUG][role063] cmdComp::Connection: SQL text is: SELECT *

      FROM (

        select * from tableau.batters

      ) "Custom SQL Query"

      Thanks in advance!

       

      Dylan