# \#json

**URL:** https://discourse.getdbt.com/tag/json/30.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [Loading JSON file using dbt core](https://discourse.getdbt.com/t/loading-json-file-using-dbt-core/11645)

<div class="topic-metadata">

**Author:** [@saikrishna.arram6995](https://discourse.getdbt.com/u/saikrishna.arram6995)\
**Replies:** 0\
**Last updated:** [January 18, 2024, 10:16am UTC](https://discourse.getdbt.com/t/loading-json-file-using-dbt-core/11645 "2024-01-18T10:16:58Z")

</div>

Hi all, I am new to dbt tool and I have a requirement to use the JSON file and load the data into Snowflake DB in one of my projects. I couldn’t find enough documentation or examples on how to use the JSON files. Would…

---

## [Data from results and manifest json files](https://discourse.getdbt.com/t/data-from-results-and-manifest-json-files/10094)

<div class="topic-metadata">

**Author:** [@amavropoulos](https://discourse.getdbt.com/u/amavropoulos)\
**Replies:** 0\
**Last updated:** [September 27, 2023, 7:56am UTC](https://discourse.getdbt.com/t/data-from-results-and-manifest-json-files/10094 "2023-09-27T07:56:07Z")

</div>

Hello everyone, We are using dbt-dataquality and dbt-expectations packages to better our tests. The issue we have been facing is the best way to extract data from the results and manifest json files. We are uploading th…

---

## [Analytics on data provided by a API](https://discourse.getdbt.com/t/analytics-on-data-provided-by-a-api/8706)

<div class="topic-metadata">

**Author:** [@steff123](https://discourse.getdbt.com/u/steff123)\
**Replies:** 1\
**Last updated:** [June 14, 2023, 11:39pm UTC](https://discourse.getdbt.com/t/analytics-on-data-provided-by-a-api/8706 "2023-06-14T23:39:29Z")

</div>

The problem I’m having Hello folks, I want to start a small hobby project. My goal is to collect financial data from a few APIs in a database and then make them evaluable with dbt and Lightdash. So far, I have no exper…

---

## [Passing a JSON value to a dbt macro](https://discourse.getdbt.com/t/passing-a-json-value-to-a-dbt-macro/1247)

<div class="topic-metadata">

**Author:** [@dylan.delport](https://discourse.getdbt.com/u/dylan.delport)\
**Replies:** 1\
**Last updated:** [June 12, 2020, 11:43am UTC](https://discourse.getdbt.com/t/passing-a-json-value-to-a-dbt-macro/1247 "2020-06-12T11:43:19Z")

</div>

Hi all, I’m starting out with Macros and created one which looks up a value in a table and returns the value. I’m passing in a Foreign Key ID however this key is stored in JSON. I am utilizing Snowflake as the Data Ware…

---

## [Handling unstructured data from MongoDB](https://discourse.getdbt.com/t/handling-unstructured-data-from-mongodb/856)

<div class="topic-metadata">

**Author:** [@tzkabir](https://discourse.getdbt.com/u/tzkabir)\
**Replies:** 1\
**Last updated:** [February 4, 2020, 1:10am UTC](https://discourse.getdbt.com/t/handling-unstructured-data-from-mongodb/856 "2020-02-04T01:10:44Z")

</div>

Hi everyone, Our MongoDB has unstructured data that we are bringing in as a string - such as: {"\_eventid": "1234", "Keywords":""} {"\_eventid": "4567", "Keywords":{"signup":True} } When it comes to DBT, what is best pr…