Package io.github.jdbcx

Interface JdbcDialect

All Known Implementing Classes:
ClickHouseDialect, DefaultDialect, DuckDBDialect
public interface JdbcDialect

  • Method Details

    • getVariableTag

      default VariableTag getVariableTag()

    • getValueFactory

      default ValueFactory getValueFactory(Format format)

    • getMapper

      ResultMapper getMapper()

    • getRemoteTable

      default String getRemoteTable(Connection conn, String url) throws SQLException
      Gets table representing the given URL. This is typically used in a query like shown below. 
       select * from {{ bridge.db.mysql1: select 1 }}
      The inner query will be translated to 'http://bridge-server:8080/<uuid>.csv' by default. This various on different databases, for examples:
      • On DuckDB, it's read_csv('http://bridge-server:8080/<uuid>.csv', auto_detect=true)
      • On ClickHouse, url table function will be used, so it becomes url('http://bridge-server:8080/<uuid>.csv', 'CSVWithNames')
      Parameters:
      conn - connection
      url - url
      Returns:
      table representing the given URL
      Throws:
      SQLException