Timothy Dobbins

Results 76 issues of Timothy Dobbins

Like: ``` %%sql select * from table | .sort_values(, ascending=False).Column.unique() ```

Doing this first: ``` %%sql --hook tables CC = USE {0}; SELECT * FROM INFORMATION_SCHEMA.TABLES; ``` then: ``` %%sql --hook --var=df list ``` failed to assign the results of this...

for instance ``` %%sql --hook tables MSS = USE {0}; SELECT * FROM sys.Tables; columns_mss MSS = EXEC sp_columns {0}; columns_db1 DB1 = EXEC sp_columns {0}; views mssql+pymssql://username:password@hostname/DB = USE...

be able to visualize tables/columns and explore via the openquery functionality

it will currently install to the current working dir, so you could have multiple sqlcell.db instances with different data. allow user to control where sqlcell.db gets written to

``` %%sql --cols=100 select top 1000 * from foo ```

current column ordering is done alphabetically.