Skip to content

Facing Database Enviornment Issue #1063

@Debahacker

Description

@Debahacker

Since Yesterday, while I was running all the queries just as it is I didn't face any issue. But since today, whenever I am trying to run a query I am shown this same error.
"KeyError Traceback (most recent call last)
/tmp/ipython-input-53-3512846643.py in <cell line: 0>()
----> 1 get_ipython().run_cell_magic('sql', '', "SELECT *\nFROM information_schema.columns\nWHERE table_name = 'customers'\n")

6 frames
/usr/local/lib/python3.11/dist-packages/google/colab/_shell.py in run_cell_magic(self, magic_name, line, cell)
274 if line and not cell:
275 cell = ' '
--> 276 return super().run_cell_magic(magic_name, line, cell)
277
278

/usr/local/lib/python3.11/dist-packages/IPython/core/interactiveshell.py in run_cell_magic(self, magic_name, line, cell)
2471 with self.builtin_trap:
2472 args = (magic_arg_s, cell)
-> 2473 result = fn(*args, **kwargs)
2474 return result
2475

in execute(self, line, cell, local_ns)

/usr/local/lib/python3.11/dist-packages/IPython/core/magic.py in (f, *a, **k)
185 # but it's overkill for just that one bit of state.
186 def magic_deco(arg):
--> 187 call = lambda f, *a, **k: f(*a, **k)
188
189 if callable(arg):

in execute(self, line, cell, local_ns)

/usr/local/lib/python3.11/dist-packages/IPython/core/magic.py in (f, *a, **k)
185 # but it's overkill for just that one bit of state.
186 def magic_deco(arg):
--> 187 call = lambda f, *a, **k: f(*a, **k)
188
189 if callable(arg):

/usr/local/lib/python3.11/dist-packages/sql/magic.py in execute(self, line, cell, local_ns)
217 return value
218 except ValueError:
--> 219 raise TraitError("{}: displaylimit is not an integer".format(value))
220
221 @observe("autopandas", "autopolars")

/usr/local/lib/python3.11/dist-packages/sql/run.py in run(conn, sql, config, user_namespace)

/usr/local/lib/python3.11/dist-packages/sql/run.py in init(self, sqlaproxy, config)

KeyError: 'DEFAULT'
"
Please kindly look into this issue.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions