How to specify dialect_properties in ini file for SqlAlchemyApi

jramineni · October 15, 2020, 7:28pm

In ini file did add dialect_properties for a sqlAlchemy , but when i print the value for dialect_properties in the interpreter is None.

This is the section in ini file, to set quote character
[[[splicedbsql]]]
name = splicedb
interface=sqlalchemy
dialect_properties=’{“sql_identifier_quote”:"""}’
options=’{“url”: “splicemachinesa://${USER}:${PASSWORD}@localhost1527/mydb”}’

Tried other settings dialect_properties is always None

Romain · October 17, 2020, 3:26am

if more a Hue property for the configuration of connectors https://issues.cloudera.org/browse/HUE-8758

First would be to add a splicedb section in:

github.com

cloudera/hue/blob/master/desktop/core/src/desktop/lib/connectors/types.py#L167


    'has_table': True,
    'has_live_queries': False,
    'has_optimizer_risks': True,
    'has_optimizer_values': True,
    'has_auto_limit': False,
    'has_reference_language': False,
    'has_reference_functions': False,
    'trim_statement_semicolon': True,
  }
},
{
  'nice_name': "SparkSQL",
  'dialect': 'sparksql',
  'interface': 'sqlalchemy',
  'settings': [
    {'name': 'api_url', 'value': 'http://sparksql-thrift-server:10000'},
    {'name': 'has_ssh', 'value': False},
    {'name': 'ssh_server_host', 'value': '127.0.0.1'},
  ],
  'category': 'editor',
  'description': '',

Would you be able to send a pull request for this?

Note: we could then also document SpliceDB in https://docs.gethue.com/administrator/configuration/connectors/ too