ipython-sql

ipython-sql copied to clipboard

ipython-sql new version ValueError: No closing quotation

1

I installed the new version of ipython-sql with ``` git clone https://github.com/catherinedevlin/ipython-sql.git pip install ipython-sql ``` This is the code I made a simple select in a string and run...

fawolfmann

How to connect hive/presto with connect_args?

6

I can connect hive/presto using `create_engine` like this ``` from sqlalchemy.engine import create_engine conn = create_engine( 'presto://user@host:port', connect_args={'protocol': 'https', 'requests_kwargs': { 'auth': HTTPBasicAuth('user', 'pw'), 'verify': '/cert.pem', }} ) df =...

cqcn1991

Assignment operator << for multiline sql statements not working

11

If I understand the documentation correctly in order for me to store the query output to the variable "works" I can use "

Databoy555

 The error message is as above. There is @ symbbol at password, so I have tried two cases: with @ or replace @ with %40, neither works. Could you...

XueWang2019

Intellisense seems not to work in VSCode, at least for resultSet.DataFrame() and the returned NDFrame object when used in jupyter notebooks.

sandimschuh

Database URL visible by default: how to anonymise

2

I am in the situation where I want to possibly make my notebooks publicly available, but I am concerned with the visibility of the connection string. Currently the following happens...

TobiasSkovgaardJepsen

This code ``` %%sql result

lukedyer-peak

Error when connecting to database

1

Error: Connection info needed in SQLAlchemy format, example: postgresql://username:password@hostname/dbname or an existing connection: dict_keys([]) invalid literal for int() with base 10: '' Connection info needed in SQLAlchemy format, example: postgresql://username:password@hostname/dbname...

SantiDu

pandas dataframe display - hide index column

1

When displaying a pandas dataframe returned from a SQL query, the dataframe is displayed along with its index column. It would be useful to display just the table as returned...

psychemedia

I have the following error when I execute this sql query: ``` %load_ext sql %config SqlMagic.autopandas = True %sql xxxx import IPython import pandas as pd import numpy as np...

qleguennec