# snowflake-meta-express-api > The snowflake-meta-express-api is likely a Node.js library designed to handle snowflake operations within an Express.js API framework. Latest version **1.0.6** (published 2024-02-23) · ISC license · 0 weekly downloads ## Install ```sh npm install snowflake-meta-express-api pnpm add snowflake-meta-express-api yarn add snowflake-meta-express-api bun add snowflake-meta-express-api ``` ## Health **Score 15/100 (F)** — status: abandoned. Positive: no vulnerabilities. Warnings: low downloads; no types; no esm support. Negative: abandoned; low maintenance score. ## Facts | | | |---|---| | Version | 1.0.6 | | Published | 2024-02-23 | | First published | 2024-02-23 | | Weekly downloads | 0 | | License | ISC | | TypeScript types | none | | Module format | CommonJS | | Dependencies | 5 | | Unpacked size | 19.6 KB | | Known vulnerabilities | 0 (+3 in 1 direct dependencies) | | Install scripts | no | | Author | Srinivasan | | Maintainers | srinivasan-bigdata | | Keywords | snowflake-meta, express | ## Links - npm: https://www.npmjs.com/package/snowflake-meta-express-api - Repository: https://github.com/SrinivasanBigData/snowflake-meta-express-api - Homepage: https://github.com/SrinivasanBigData/snowflake-meta-express-api#readme - Issues: https://github.com/SrinivasanBigData/snowflake-meta-express-api/issues - npm.io page: https://npm.io/package/snowflake-meta-express-api ## Dependencies (5) - [dotenv](https://npm.io/package/dotenv.md) ^16.4.5 - [express](https://npm.io/package/express.md) ^4.18.2 - [sql-parser](https://npm.io/package/sql-parser.md) ^0.5.0 - [body-parser](https://npm.io/package/body-parser.md) ^1.20.2 - [snowflake-sdk](https://npm.io/package/snowflake-sdk.md) ^1.9.3 ## Recent versions - 1.0.6 (latest) — 2024-02-23 - 1.0.5 — 2024-02-23 - 1.0.4 — 2024-02-23 - 1.0.3 — 2024-02-23 - 1.0.2 — 2024-02-23 - 1.0.1 — 2024-02-23 - 1.0.0 — 2024-02-23 ## README # snowflake-meta-express-api The `snowflake-meta-express-api` is likely a Node.js library designed to handle snowflake metadata operations within an Express.js API framework. This library facilitates seamless interaction with Snowflake roles, databases, warehouses, schemas, tables, and querying data in Snowflake. ## Installation You can install `snowflake-meta-express-api` via npm: ```sh npm install snowflake-meta-express-api ``` ## Usage ```javascript const express = require("express"); const snowflakeMeta = require("snowflake-meta-express-api"); const app = express(); app.use("/api", snowflakeMeta); app.listen(3000, () => { console.log("Server is running on port 3000"); }); ``` ## Create/Update Environemt Variable(`.env`) ```ruby CRYPTO_ALOGORITHM=aes-256-cbc CRYPTO_PASSWORD= # update password ``` ## Query Parameters: 1. **page**: Page number (default: 1) 2. **pageSize**: Number of items per page (default: 10) 3. **pattern**: Search pattern (optional) 4. **db**: Search from database (optional) ## Common Connection Configration Payload 1. Simple Common Payload ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` 2. Encrypted Payload ```json { "connectionConfig": "f4ef3dbd2f636e4a0141bd2f", "iv": "4c048c295ea6a5a75ea97b3110f98887" } ``` ## Features - **Roles**: Enabled API endpoints to get the list of roles based on the logged-in user from Snowflake based on pagination with pattern search. - **API Endpoint**: `POST /api/snowflake/roles` - **Supported QueryParams**: `page,pageSize,pattern` - **Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` - **Databases**: Enabled API endpoints to get the list of Databases from Snowflake based on pagination with pattern search. - **API Endpoint**: `POST /api/snowflake/databases` - **Supported QueryParams**: `page,pageSize,pattern` - **Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` - **Warehouses**: Enabled API endpoints to get the list of warehouses from Snowflake based on pagination with pattern search. - **API Endpoint**: `POST /api/snowflake/warehouses` - **Supported QueryParams**: `page,pageSize,pattern` - **Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` - **Schemas**: Enabled API endpoints to get the list of Schemas from Snowflake based on pagination with pattern search. - **API Endpoint**: `POST /api/snowflake/schemas` - **Supported QueryParams**: `page,pageSize,pattern,db` - **SampleDB Params**: `?db=` - **Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` - **Tables**: Enabled API endpoints to get the list of Tables from Snowflake based on pagination with pattern search. - **API Endpoint**: `POST /api/snowflake/tables` - **Supported QueryParams**: `page,pageSize,pattern,db` - **SampleDB Params**: `?db=.` - **Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` - **Data**: Enabled API endpoints to retrive data from Snowflake based on payload Query. - **API Endpoint**: `POST /api/snowflake/query` - **Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 }, "query": "SELECT * FROM .. LIMIT 100" } ``` - **Encrypt**: Enabled API endpoints to Encrypt the payload Data - **API Endpoint**: `POST /api/crypto/encrypt` - **Sample Request Body**: ```json { "connectionConfig": { "account": "", "username": "", "password": "", "port": 443 } } ``` **Note**: Request Body can be any data format. ## Contributing Thank you for considering contributing to `snowflake-meta-express-api` Contributions are welcome from everyone ## Issues If you encounter any issues with the library, please feel free to open an issue on GitHub. Provide as much detail as possible, including code examples and error messages if applicable. --- _Source: https://npm.io/package/snowflake-meta-express-api · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._