No module named redash.query_runner

[caos2060]

Hello good evening!

my failure occurs when executing the pg.py file

I followed the documentation

How can I add new data source programmatically

This API isn’t documented. But you can see which variables are needed in the configuration_schema for any query runner. For example, the postgres query runner can be found here. I pasted the applicable portion below: { "type": "object", "properties": { "user": {"type": "string"}, "password": {"type": "string"}, "host": {"type": "string", "default": "127.0.0.1"}, "port": {"type": "number", "default": 5432}, …

and I can’t get out of the error.

I would appreciate your help, I am trying to enter the “datasource” programmatically

implement the following solutions without success:

1. edit “docker_compose.yml”

2. add line “REDASH_ADDITIONAL_QUERY_RUNNERS:” redash.query_runner.python “”

example in the picture

following the documentation:

How to enable python as a data source?

Thanks, but this link seems to be for non-docker installation。@ ariarijp

3. stop service “sudo docker-compose stop”
   3.1 delete containers “sudo docker-compose rm”
   3.2 re-deploy images redash “sudo docker-compose run --rm server create_db
   sudo docker-compose up -d”

[jesse]

This is an import error because of your PYTHONPATH. But really, you shouldn’t try to execute pg.py from your terminal. It’s not designed for this at all. Particularly since it imports other assets from the Redash package.

You linked to some instructions I wrote which show you how how to find which fields are required when creating a data source. You do this by looking at the configuration schema for the data source. But you would never actually run the file. You’re just getting the field names so you can make an HTTP request to api/data_sources with the correct info.

[caos2060]

Thanks for your quick response, I still have a question!

in which path do I put the .json file?

[caos2060]

@jesse

api/data_sources

it allows me to perform the “API CALL”, but now it gives me this error

[jesse]

What kind of request did you try? GET? POST?

[caos2060]

POST Method !

I already found the solution, the error is now authentication.

I am passing the user’s key like this:

[jesse]

That’s not how Redash authenticates

Replace the word basic with key

[caos2060]

sorry i am new to using CALL API, i did what you tell me but i keep getting this error.

my problem is that I don’t really know where to put the “api-key”

[jesse]

Key belongs in the quotes.