get_schema_names() doesn't work about clickhouse-sqlalchemy

[xzkostyan]

Hi.

Long story short. You have two options:

• correct schema to native uri = 'clickhouse+native://default:@localhost';
• patch get_schema_names to use .execute('SHOW DATABASES FORMAT TabSeparatedWithNamesAndTypes') if you want to use http driver.

There are two drivers for ClickHouse dialect in this package: http and native. Unfortunately I don't have time and efforts to support both of them. Therefore I'm focusing on native driver support. So, recommended schema for DSN is clickhouse+native://. But PRs for http driver are appreciated. Yep, clickhouse+native driver is not default right now.

Back to your problem. If you are using http driver and raw engine.execute you should add FORMAT TabSeparatedWithNamesAndTypes to your query for determining columns with their names. It seems to be valid bug right now for http driver.

[xzkostyan]

Version 0.1.2 contains fix of this bug.

[xzkostyan]

@villebro should we close this issue?