Hi! After the Dremio and GoodDataCN webinar, I was...
# gooddata-cnb
BRENO ZIPOLI MONTEIRO PAPA
03/29/2022, 6:25 PMHi! After the Dremio and GoodDataCN webinar, I was trying to integrate a SQL Database with Dremio (which worked) and then Dremio to GoodDataCN as a DataSource. After using the API to create the datasource, when I press to scan the datasource, no schemas are presented (0 of 0) even though I have used the schema SPON010117864.P12133MNTDB.gooddata, present on Dremio. Dremio was initialized as a docker image with the standard documentation commands (and ports), just like GDCN. Any hints?
j
Jan Soubusta
03/30/2022, 7:39 AMFirst, please, try the following:
1. Specify empty dataSource.schema (empty string). Check if all Dremio schemata are displayed in LDM Modeler
2. Go to web browser console in LDM Modeler when scan dialog is displayed. Is there any error?
t
Thomas Pedot
03/30/2022, 9:33 AMHi, think I am in the same situation. When do you think it will be updated ?
j
Jan Soubusta
03/30/2022, 11:28 AMI hope we will deliver the fix (errors displayed in LDM Modeler UI) in the next release 1.8. There has not been set exact release date yet. Can we give a rough estimate, @Martin Svadlenka @Ondrej Macek?
Jan Soubusta
03/30/2022, 11:44 AMAnyway, as a workaround you can get errors from the web console.
In case of status=400, there should be human readable error message explaining the root cause. In case of status=500, traceId should be there, which helps to investigate it in our monitoring (GD cloud Beta) or in on-premise monitoring or k8s/docker logs.
👀 1
b
BRENO ZIPOLI MONTEIRO PAPA
03/30/2022, 12:36 PMDeclaring empty string as schema and checking web console I am getting these errors:
Failed to load resource: the server responded with a status of 400 (Bad Request).
The workaround was to instead of declaring "url" as:
"url": "jdbcdremiodirect=dremio:31010",
I declared as:
"url": "jdbcdremiodirect=192.168.15.14:31010" (machine's local ip)
Using this, I was even able to declare the schema correctly.
j
Jan Soubusta
03/30/2022, 2:27 PMAm I correct that you start GD.CN and Dremio locally? Do you start them as separate containers or do you use a docker-compose file? What docker distribution do you use? What OS?
Generally, we recommend to utilize the docker-compose, which ensures all containers are running in the same network. Then the first jdbcUrl should work.
b
BRENO ZIPOLI MONTEIRO PAPA
03/30/2022, 7:12 PM@Jan Soubusta indeed I started them as separate containers. I am using docker desktop 4.6.1 (76265) in Windows.
j
Jan Soubusta
03/30/2022, 7:57 PMPlease, try to use docker-compose. Sample d-c yaml can be found in our public doc, page related to Dremio
m
Martin Svadlenka
03/31/2022, 9:53 PMHi @BRENO ZIPOLI MONTEIRO PAPA , as Jacek mentioned, we will be releasing 1.8 release. So far scheduled for end of June, however we will release few minor versions and fixes during beta. Will keep you informed.