首页 > 数据库 >二 Superset通过API创建数据库连接和数据集

二 Superset通过API创建数据库连接和数据集

时间：2024-03-21 15:36:17浏览次数：29  
标签：Superset false name database true 数据库 API null type

Superset通过API创建数据库连接和数据集

1 登录

Post 登录

http://localhost:8088/api/v1/security/login

Body raw(json)

{
    "password": "123456",
    "provider": "db",
    "refresh": true,
    "username": "admin"
}

Example

Request

POST /api/v1/security/login HTTP/1.1
Host: localhost:8088
Content-Length: 101

{
    "password": "123456",
    "provider": "db",
    "refresh": true,
    "username": "admin"
}

Response

{
    "access_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJmcmVzaCI6dHJ1ZSwiaWF0IjoxNzExMDAyNjY3LCJqdGkiOiIyODc4MjZlNS02NTBmLTQwNTktYTEzMC0zNmYwNGIxODE5MWQiLCJ0eXBlIjoiYWNjZXNzIiwic3ViIjoxLCJuYmYiOjE3MTEwMDI2NjcsImNzcmYiOiJiNTEyYzc3Zi0zMjc2LTQyN2YtYjliYy05Nzc4NGE3MmVhN2QiLCJleHAiOjE3MTEwMDM1Njd9.MIxUUuOo3h_IGFOSO_kAhO1kQfAL6NQ8upXTLOEYaMY",
    "refresh_token": "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJmcmVzaCI6ZmFsc2UsImlhdCI6MTcxMTAwMjY2NywianRpIjoiMjFiNjVjMjgtMjBjYi00MjZmLWJlNTAtY2I2NDA2YzFmNGIxIiwidHlwZSI6InJlZnJlc2giLCJzdWIiOjEsIm5iZiI6MTcxMTAwMjY2NywiY3NyZiI6ImQ5ZDhjYTQzLTU3ZWUtNDc0ZC1hOTY5LWVhZTAyNTcyY2EzYiIsImV4cCI6MTcxMzU5NDY2N30.ynpSE9MQHodjxl_7QTcvKMIkIHgJXjxVElHDxeCZs4Y"
}

2 创建数据库连接

笔记

需要把登录接口返回的access_token设置到Authorization Bearer Token,用于权限验证

Post 新增数据源

http://localhost:8088/api/v1/database/

Authorization Bearer Token

Token <access_token>

Body raw(json)

{"engine":"mysql","configuration_method":"sqlalchemy_form","database_name":"MySQL6","sqlalchemy_uri":"mysql://root:[email protected]:3306/superset"}

Example

Request

POST /api/v1/database/ HTTP/1.1
Host: localhost:8088
Content-Length: 151

{"engine":"mysql","configuration_method":"sqlalchemy_form","database_name":"MySQL6","sqlalchemy_uri":"mysql://root:[email protected]:3306/superset"}

Response

{
    "id": 1,
    "result": {
        "configuration_method": "sqlalchemy_form",
        "database_name": "MySQL6",
        "driver": "mysqldb",
        "expose_in_sqllab": true,
        "parameters": {
            "database": "superset",
            "encryption": false,
            "host": "192.168.31.111",
            "password": "XXXXXXXXXX",
            "port": 3306,
            "query": {},
            "username": "root"
        },
        "sqlalchemy_uri": "mysql://root:[email protected]:3306/superset",
        "uuid": "7d873883-0762-4bdc-8038-8ae35cd782b2"
    }
}

3 创建数据集

笔记

需要把创建数据库连接接口返回的id设置传递到databse参数

Post 新增数据集

http://localhost:8088/api/v1/dataset/

Authorization Bearer Token

Token <access_token>

Body raw(json)

{
  "database": 1,
  "schema": "bj_ld",
  "table_name": "222"
}

Example

Request

POST /api/v1/dataset/ HTTP/1.1
Host: localhost:8088
Content-Length: 67

{
  "database": 1,
  "schema": "bj_ld",
  "table_name": "222"
}

Response

{
    "data": {
        "always_filter_main_dttm": false,
        "cache_timeout": null,
        "column_formats": {},
        "columns": [
            {
                "advanced_data_type": null,
                "certification_details": null,
                "certified_by": null,
                "column_name": "name",
                "description": null,
                "expression": null,
                "filterable": true,
                "groupby": true,
                "id": 1,
                "is_certified": false,
                "is_dttm": false,
                "python_date_format": null,
                "type": "VARCHAR(255)",
                "type_generic": 1,
                "verbose_name": null,
                "warning_markdown": null
            },
            {
                "advanced_data_type": null,
                "certification_details": null,
                "certified_by": null,
                "column_name": "type",
                "description": null,
                "expression": null,
                "filterable": true,
                "groupby": true,
                "id": 2,
                "is_certified": false,
                "is_dttm": false,
                "python_date_format": null,
                "type": "VARCHAR(255)",
                "type_generic": 1,
                "verbose_name": null,
                "warning_markdown": null
            },
            {
                "advanced_data_type": null,
                "certification_details": null,
                "certified_by": null,
                "column_name": "length",
                "description": null,
                "expression": null,
                "filterable": true,
                "groupby": true,
                "id": 3,
                "is_certified": false,
                "is_dttm": false,
                "python_date_format": null,
                "type": "DOUBLE",
                "type_generic": 0,
                "verbose_name": null,
                "warning_markdown": null
            }
        ],
        "currency_formats": {},
        "database": {
            "allows_cost_estimate": false,
            "allows_subquery": true,
            "allows_virtual_table_explore": true,
            "backend": "mysql",
            "configuration_method": "sqlalchemy_form",
            "disable_data_preview": false,
            "engine_information": {
                "disable_ssh_tunneling": false,
                "supports_file_upload": true
            },
            "explore_database_id": 1,
            "id": 1,
            "name": "MySQL6",
            "parameters": {
                "database": "superset",
                "encryption": false,
                "host": "192.168.31.111",
                "password": "XXXXXXXXXX",
                "port": 3306,
                "query": {},
                "username": "root"
            },
            "parameters_schema": {
                "properties": {
                    "database": {
                        "description": "Database name",
                        "type": "string"
                    },
                    "encryption": {
                        "description": "Use an encrypted connection to the database",
                        "type": "boolean"
                    },
                    "host": {
                        "description": "Hostname or IP address",
                        "type": "string"
                    },
                    "password": {
                        "description": "Password",
                        "nullable": true,
                        "type": "string"
                    },
                    "port": {
                        "description": "Database port",
                        "maximum": 65536,
                        "minimum": 0,
                        "type": "integer"
                    },
                    "query": {
                        "additionalProperties": {},
                        "description": "Additional parameters",
                        "type": "object"
                    },
                    "ssh": {
                        "description": "Use an ssh tunnel connection to the database",
                        "type": "boolean"
                    },
                    "username": {
                        "description": "Username",
                        "nullable": true,
                        "type": "string"
                    }
                },
                "required": [
                    "database",
                    "host",
                    "port",
                    "username"
                ],
                "type": "object"
            },
            "schema_options": {}
        },
        "datasource_name": "222",
        "default_endpoint": null,
        "description": null,
        "edit_url": "/tablemodelview/edit/1",
        "extra": null,
        "fetch_values_predicate": null,
        "filter_select": true,
        "filter_select_enabled": true,
        "granularity_sqla": [],
        "health_check_message": null,
        "id": 1,
        "is_sqllab_view": false,
        "main_dttm_col": null,
        "metrics": [
            {
                "certification_details": null,
                "certified_by": null,
                "currency": null,
                "d3format": null,
                "description": null,
                "expression": "COUNT(*)",
                "id": 1,
                "is_certified": false,
                "metric_name": "count",
                "verbose_name": "COUNT(*)",
                "warning_markdown": null,
                "warning_text": null
            }
        ],
        "name": "bj_ld.222",
        "normalize_columns": false,
        "offset": 0,
        "order_by_choices": [
            [
                "[\"length\", true]",
                "length 基础"
            ],
            [
                "[\"length\", false]",
                "length [desc]"
            ],
            [
                "[\"name\", true]",
                "name 基础"
            ],
            [
                "[\"name\", false]",
                "name [desc]"
            ],
            [
                "[\"type\", true]",
                "type 基础"
            ],
            [
                "[\"type\", false]",
                "type [desc]"
            ]
        ],
        "owners": [
            {
                "first_name": "admin",
                "id": 1,
                "last_name": "user",
                "username": "admin"
            }
        ],
        "params": null,
        "perm": "[MySQL6].[222](id:1)",
        "schema": "bj_ld",
        "select_star": "SELECT *\nFROM bj_ld.`222`\nLIMIT 100",
        "sql": null,
        "table_name": "222",
        "template_params": null,
        "time_grain_sqla": [
            [
                "PT1S",
                "Second"
            ],
            [
                "PT1M",
                "Minute"
            ],
            [
                "PT1H",
                "Hour"
            ],
            [
                "P1D",
                "Day"
            ],
            [
                "P1W",
                "Week"
            ],
            [
                "P1M",
                "Month"
            ],
            [
                "P3M",
                "Quarter"
            ],
            [
                "P1Y",
                "Year"
            ],
            [
                "1969-12-29T00:00:00Z/P1W",
                "Week starting Monday"
            ]
        ],
        "type": "table",
        "uid": "1__table",
        "verbose_map": {
            "__timestamp": "Time",
            "count": "COUNT(*)",
            "length": "length",
            "name": "name",
            "type": "type"
        }
    },
    "id": 1,
    "result": {
        "always_filter_main_dttm": false,
        "database": 1,
        "normalize_columns": false,
        "schema": "bj_ld",
        "table_name": "222"
    }
}

通过以上步骤,我们已经可以通过API完成数据集和数据连接的构建

问: 为什么不通过UI界面来处理这些事情?

答: BI工具集成到我们的系统中后,面相的使用者是用户,让用户来连数据库,和从海量的数据库中选择要进行分析的表是很不合理,把数据库暴露给用户也是很不安全的行为,通过API来完成会让这个过程更加的可控

标签：Superset,false,name,database,true,数据库,API,null,type
From： https://www.cnblogs.com/wangyequn/p/18087481

相关文章

  • OLAP数据库选型指南：Doris与ClickHouse的深入对比与分析
    码到三十五：个人主页心中有诗画，指尖舞代码，目光览世界，步履越千山，人间尽值得!在当今数据驱动的时代，数据的存储、处理和分析变得尤为重要。为了满足这一需求，市场上涌现出了许多优秀的数据处理和分析工具。其中，Doris和ClickHouse是两个备受关注的开源项目。本......
  • kernel BUG at arch/x86/kernel/apic/vector.c:174!
    问题兆芯设备适配ngrayos系统(debian系统4.20.1内核)时，在网口up时系统崩溃。版本如下：现象：经过排查，原因是因为兆芯设备启动参数加了noapic（不加系统无法正常刻录和启动），网口up时中断向量不够分配。APIC（AdvancedProgrammableInterruptController）是一种硬件设备，用于处......
  • 什么是API?
    什么是API?API(ApplicationProgramminginterface)应用程序编程接口。简单来说：就是Java帮我们已经写好的一些类和方法，我们直接拿过来用就可以了常用API:ScannerRandomStringStringBuilder作用：大量操作字符串的时候，提高效率ArrayList:作用：存储数据的个......
  • 速卖通API接口推荐：速卖通商品详情数据接口
    速卖通商品详情数据接口是一个官方提供的API接口，它可以帮助您获取商品详情、店铺信息以及交易数据等重要信息。以下是关于速卖通商品详情数据接口的一些建议：注册账号：您需要在速卖通官网注册账号，并通过实名认证。或者是通过python,php,java,c等开发语言进行封装速卖通商品详情......
  • 全网最全最稳定中文ISBN信息查询api接口
     基本说明：接口地址：http://data.isbn.work/openApi/getInfoByIsbn?isbn={isbn}&appKey={appkey}返回格式：json请求方式：get请求示例：http://data.isbn.work/openApi/getInfoByIsbn?isbn=9787513159074&appKey=ae1718d4587744b0b79f940fbef69e77伽薇 809137232请求参数说明：名......
  • 使用API有效率地管理Dynadot域名，使用API为域名进行续费
    关于DynadotDynadot是通过ICANN认证的域名注册商，自2002年成立以来，服务于全球108个国家和地区的客户，为数以万计的客户提供简洁，优惠，安全的域名注册以及管理服务。Dynadot平台操作教程索引（包括域名邮箱，解析，建站，优惠长期更新）Dynadot.com提供的API是专为效率而构建的高级域名管理......
  • vSAN HCL数据库版本及版本目录告警处理
    原文链接：https://blog.csdn.net/andycnm/article/details/129661646vSANHCL数据库版本更新https://partnerweb.vmware.com/service/vsan/all.json右键单击，另存为all.json，如果无法保存文件，则必须复制整个内容并创建扩展名为“*.json".的新文件。将文件上传更新   vSA......
  • 【Mysql数据库基础01】去重、连接字符、模糊查询、通配符、检索表的结构信息
    去重、连接字符、模糊查询、通配符、检索表的结构信息1去重distinct2连接字符函数concat(str1,str2,...)3模糊查询3.1like包含3.2通配符3.3betweenand3.4in3.5isnull4安全等于<=>5检索表的结构信息desc6课后练习1去重distinct使用DISTINCT关......
  • MVC和.net6,API的body在过滤器中重复消费
    在MV中privateasyncTask<string>ReadPostDataAsync(HttpActionContextactionContext,CancellationTokencancellationToken){stringpostData="";varrequestStream=awaitactionContext.Request.Content.ReadAsS......
  • linq链接数据库SQL封装类
    linq链接数据库SQL封装类首先，需要定义一个LINQtoSQL的上下文类，这个类是从DataContext继承而来，并且包含了映射到数据库表的实体类。[Database(Name="MyDatabase")]publicclassMyDataContext:DataContext{publicTable<User>Users;publicMyDataContext(stri......

赞助商

阅读排行

网站主页关于我们联系我们网站地图

本网站内容转载自其他媒体，侵权联系[admin##ips99.com]。

Copyright © 2020-2023 IPS99 版权所有 IPS99