You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I tried adding a sample user report to metabase v0.44.6 using this driver, and it worked. I can see and explore the content of the .csv file just fine but when I checked metabase's logs I see errors.
I'll post a partial error log here, if you need more please let me know.
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 INFO metabase.sync.util STARTING: Analyze data for csv Database 36 'GData sample reports'
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for csv Database 36 'GData sample reports'
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 INFO metabase.sync.analyze fingerprint-fields Analyzed [************······································] 😒 25% Table 101 'PUBLIC.sample-user-report'
[49cf1a7a-8997-4408-959e-ddc4e16679f0] 2022-12-01T19:26:24+01:00 WARN metabase.sync.util Error fingerprinting Table 101 'PUBLIC.sample-user-report'
clojure.lang.ExceptionInfo: Error executing query: Syntax error: derived tables not supported {:sql "-- Metabase\nSELECT \"source\".\"substring594\" AS \"substring594\", \"source\".\"substring595\" AS \"substring595\", \"source\".\"substring596\" AS \"substring596\", \"source\".\"substring597\" AS \"substring597\", \"source\".\"substring598\" AS \"substring598\", \"source\".\"substring599\" AS \"substring599\", \"source\".\"substring600\" AS \"substring600\", \"source\".\"substring601\" AS \"substring601\", \"source\".\"substring602\" AS \"substring602\", \"source\".\"substring603\" AS \"substring603\" FROM (SELECT \"PUBLIC\".\"sample-user-report\".\"E-Mail-Adresse\" AS \"E-Mail-Adresse\", \"PUBLIC\".\"sample-user-report\".\"Letzter Zugriff des Benutzers\" AS \"Letzter Zugriff des Benutzers\", \"PUBLIC\".\"sample-user-report\".\"Nachname\" AS \"Nachname\", \"PUBLIC\".\"sample-user-report\".\"Vorname\" AS \"Vorname\", \"PUBLIC\".\"sample-user-report\".\"Zweige\" AS \"Zweige\", \"PUBLIC\".\"sample-user-report\".\"Name des Lernplans\" AS \"Name des Lernplans\", \"PUBLIC\".\"sample-user-report\".\"Abschlussdatum\" AS \"Abschlussdatum\", \"PUBLIC\".\"sample-user-report\".\"Einschreibungsdatum\" AS \"Einschreibungsdatum\", \"PUBLIC\".\"sample-user-report\".\"Fertigstellungsgrad\" AS \"Fertigstellungsgrad\", \"PUBLIC\".\"sample-user-report\".\"Status der Einschreibung zum Lernplan\" AS \"Status der Einschreibung zum Lernplan\", substring(\"PUBLIC\".\"sample-user-report\".\"Einschreibungsdatum\", 1, 1234) AS \"substring601\", substring(\"PUBLIC\".\"sample-user-report\".\"Vorname\", 1, 1234) AS \"substring602\", substring(\"PUBLIC\".\"sample-user-report\".\"E-Mail-Adresse\", 1, 1234) AS \"substring600\", substring(\"PUBLIC\".\"sample-user-report\".\"Letzter Zugriff des Benutzers\", 1, 1234) AS \"substring596\", substring(\"PUBLIC\".\"sample-user-report\".\"Nachname\", 1, 1234) AS \"substring595\", substring(\"PUBLIC\".\"sample-user-report\".\"Name des Lernplans\", 1, 1234) AS \"substring598\", substring(\"PUBLIC\".\"sample-user-report\".\"Zweige\", 1, 1234) AS \"substring594\", substring(\"PUBLIC\".\"sample-user-report\".\"Fertigstellungsgrad\", 1, 1234) AS \"substring597\", substring(\"PUBLIC\".\"sample-user-report\".\"Status der Einschreibung zum Lernplan\", 1, 1234) AS \"substring599\", substring(\"PUBLIC\".\"sample-user-report\".\"Abschlussdatum\", 1, 1234) AS \"substring603\" FROM \"PUBLIC\".\"sample-user-report\") \"source\" LIMIT 10000", :params nil, :type :invalid-query}
The important bits seem to be
Error executing query: Syntax error: derived tables not supported and :invalid-query
The text was updated successfully, but these errors were encountered:
I tried adding a sample user report to metabase v0.44.6 using this driver, and it worked. I can see and explore the content of the .csv file just fine but when I checked metabase's logs I see errors.
I'll post a partial error log here, if you need more please let me know.
The important bits seem to be
Error executing query: Syntax error: derived tables not supported
and:invalid-query
The text was updated successfully, but these errors were encountered: