# Big-Query-Magic
#### The package has been created for Mac OS
#### Requirements
It is assumed that you have basic packages like pandas installed
Install Auth2client and pandas_gbq
Ensure that you can query data using pandas gbq
<hr>
This packacge installs a magic in your startup directory which makes querying in jupyter environment more user friendly and easier to use.Post intallation simply type %%BQSQL and write your query
example
```python
%%BQSQL
SELECT *
FROM table
LIMIT 10;
```
<b>There are other features also present which makes it even more user friendly which can be explained with help of the argument this magic can take</b>
-job [Y or None] If Y is passed as job argument this will run just the query but will not pull the out put, this is useful when one is creating a large temp table during the workflow and does not want to download and load it in python, the existing pandas_gbq does not offer that
-save_to [Table Name] Pass a variable in which the output needs to be store
Note Do not pass both the arguments at the same time
-para [Y or None] If Y is passed the query will look if parameters or python variables are used in the query. Yes this is one of the best features of this magic you can use python variables directly in your query
example
```python
x = ['user1','user2']
%%BQSQL -para Y -job Y
SELECT *
FROM table
WHERE user_id IN @x
```
Currently string int and list of these two can be passed as a parameter. Note parameter needs to be preceeded by <b><u>@</u></b> in case one was planning to use @ just as character in that case please avaoid using parameter
程序员Chino的日记
- 粉丝: 3555
- 资源: 5万+
最新资源
- 单相光伏并网逆变器设计方案参考资料 资料包含: 1.硬件设计概要和软件设计总体方案文档; 2.Matlap Simulink仿真
- Java就业培训教程资料-pdf
- 有源滤波器(APF)主要由两大部分构成:指令电流检测部分和补偿电流生成部分 主要工作原理是检测补偿点处电压和电流,通过谐波检测
- comsol二维光子晶体角态 单胞能带,超胞能带,边界态以及角态计算
- Visual Basic for Applications(VBA) 开发资源与库大全
- hfut自然语言处理-test3-中文分词技术应用
- 基于文本挖掘的新能源汽车评论情感分析
- 苹果cms内核H5网页漫画小说系统源码/支持三级分销与对接公众号
- 电力系统暂态分析-考研必备
- AgroCounters-一个使用深度学习算法对农业领域图像中的对象进行计数的存储库:框架和评估
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈