[GitHub] [superset] ramirobg94 commented on issue #20968: DB engine Error

["ramirobg94 (via GitHub)" <gi...@apache.org>]

ramirobg94 commented on issue #20968:
URL: https://github.com/apache/superset/issues/20968#issuecomment-1509884121

   I have the same error with Postgresql and running the examples
   The database used on the query different from examples is remote, I am able to query and get the data but not able to build charts with graphics. But If I create a dataset from this query I can.
   
   
   ```
   docker build -t supersetcustom .
   docker run -d -pdocker build -t nodebb . 8080:8088 -e "SUPERSET_SECRET_KEY=KEYKEY" --name superset superset
   docker exec -it superset superset fab create-admin --username admin --firstname Superset --lastname Admin  --email admin@superset.com --password admin
   docker exec -it superset superset db upgrade
   docker exec -it superset superset load_examples
   docker exec -it superset superset init
   ```
   
   and my Dockerfile is:
   
   ```
   FROM apache/superset
   # Switching to root to install the required packages
   USER root
   # Example: installing the MySQL driver to connect to the metadata database
   # if you prefer Postgres, you may want to use `psycopg2-binary` instead
   # RUN pip install mysqlclient
   RUN pip install psycopg2
   RUN pip install psycopg2-binary
   # Example: installing a driver to connect to Redshift
   # Find which driver you need based on the analytics database
   # you want to connect to here:
   # https://superset.apache.org/installation.html#database-dependencies
   # RUN pip install sqlalchemy-redshift
   # RUN pop install sqlalchemy-bigquery
   # RUN pip install sqlalchemy-bigquery
   # Switching back to using the `superset` user
   RUN pip install sqlalchemy-bigquery
   USER superset
   ```
   
   
   <img width="1680" alt="Captura de Pantalla 2023-04-15 a las 18 05 00" src="https://user-images.githubusercontent.com/11272068/232237136-633b063d-3ae7-46b1-8cb5-1c7a597fc62b.png">
   
   <img width="1675" alt="Captura de Pantalla 2023-04-15 a las 17 49 50" src="https://user-images.githubusercontent.com/11272068/232237133-5b0c2049-950d-4cb6-9543-1bc5e15a0f8e.png">
   ![Uploading Captura de Pantalla 2023-04-15 a las 18.05.00.png…]()
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org