Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

te_init.ipynb: Can't deploy without having CREATE SCHEMA privileges #222

Open
ThomasBestfleisch opened this issue Feb 21, 2024 · 5 comments
Labels
bug Unwanted / harmful behavior

Comments

@ThomasBestfleisch
Copy link

The schema exists, but the user doesn't have the privileges to create a schema:

`
WARNING:exasol_transformers_extension.deployment.scripts_deployer:Could not create schema EXASOL_TB. Got error:
(
message => insufficient privileges for creating schema (Session: 1791518209485701122)
dsn =>
user => EXASOL_TB
schema =>
session_id => 1791518209485701122
code => 42500
query => CREATE SCHEMA IF NOT EXISTS EXASOL_TB
)


ExaQueryError Traceback (most recent call last)
Cell In[3], line 3
1 from exasol.nb_connector.transformers_extension_wrapper import initialize_te_extension
----> 3 initialize_te_extension(ai_lab_config)`

@tkilias
Copy link
Collaborator

tkilias commented Feb 22, 2024

hm, I thought we had fixed that, I will have a look

@tkilias tkilias added the bug Unwanted / harmful behavior label Feb 22, 2024
@tkilias
Copy link
Collaborator

tkilias commented Feb 22, 2024

Same is then probably true for sageamaker

@tkilias
Copy link
Collaborator

tkilias commented Feb 22, 2024

The warning is intended. If we want to disable the warning, then it is a feature.

https://github.com/exasol/transformers-extension/blob/9551f9451bc24b6f813827d3c241ba82d743de27/exasol_transformers_extension/deployment/scripts_deployer.py#L22

If it actually fails, it is a bug.

@ThomasBestfleisch
Copy link
Author

@tkilias it fails. The UDFs are not getting deployed in the database

@redcatbear
Copy link

@ahsimb , please retest next Kehrwoche.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Unwanted / harmful behavior
Projects
None yet
Development

No branches or pull requests

3 participants