pip install jinjat
poetry env use python3.9
poetry install
poetry add dbt-duckdb==1.5.0
poetry run dbt deps --project-dir ../dbt_project_dir/
poetry run jinjat serve --host 127.0.0.1 --project-dir ../dbt_project_dir/
Create an analysis in analysis/my_first_api.sql:
{%- set query = request().query %}
select '{{query.example}}' as col1And create a YML file in analysis/schema.yml:
version: 2
analyses:
- name: my_first_api
config:
jinjat:
method: get
openapi:
parameters:
- in: query
name: example
schema:
type: numberStart Jinjat as follows:
jinjat serve --project-dir [YOUR_DBT_PROJECT_DIRECTORY]
And then run the following CURL command to test the API:
curl -XGET 'http://127.0.0.1:8581?example=value'
It should return the following response:
[
"col1": "3"
]Jinjat uses OpenAPI to validate the requests and create an API documentation automatically for your API.