> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/quickstarts-1/data-ingestion-wizard/using-the-wizard.md).

# Using the Wizard

The Upsolver Data Ingestion Wizard is the easy, no-code option for ingesting your data into Amazon Redshift, AWS Glue Data Catalog, ClickHouse, Polaris Catalog, and Snowflake. Use the Wizard to create a job, or use the auto-generated code as a basis for creating more advanced use cases by extending the functionality using familiar SQL syntax. 

For Elasticsearch, Amazon S3, and PostgreSQL targets, the Wizard will provide a code template for configuring your connections and job, based on the data source you select.

The Wizard creates a job in four simple steps:

1. [Set up your source](#set-up-your-source)
2. [Set up your target](#set-up-your-target)
3. [Configure your job](#configure-your-job)
4. [Review and run the job](#review-and-run-the-job)

## Create a job with the Wizard

Login to your Upsolver account and, from the left-hand menu, click **Jobs**. On the Jobs page, click the **Create New Job** button. This opens the **Ingestion Wizard.** Click on the card for the data source from where you want to copy your data and the card for your data target:  

<figure><img src="/files/C4EAnupt6e5VAkeC7Tpv" alt=""><figcaption><p>Open the Ingestion Wizard and follow the steps to ingest your data.</p></figcaption></figure>

### Set up your source

The Wizard guides you through the steps for setting up your data source:&#x20;

* [Amazon Kinesis](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/amazon-kinesis.md)
* [Amazon S3](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/amazon-s3.md)
* [Apache Kafka](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/apache-kafka.md)
* [Confluent Cloud](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/confluent-cloud.md)
* [Microsoft SQL Server](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/microsoft-sql-server.md)
* [MongoDB](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/mongodb.md)&#x20;
* [MySQL](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/mysql.md)
* [PostgreSQL](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/postgresql.md)

### Set up your target

Follow the guide for setting up your target:

* [Amazon Redshift](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/target-set-up/amazon-redshift.md)
* [AWS Glue Data Catalog](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/target-set-up/aws-glue-data-catalog.md)
* [ClickHouse](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/target-set-up/clickhouse.md)
* [Polaris Catalog](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/target-set-up/polaris-catalog.md)
* [Snowflake](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/target-set-up/snowflake.md)

### Configure the ingestion job

Upsolver supports various data sources, from files, streaming, and CDC data. Follow the applicable guides for configuring your job based on your source:

* [Job Configuration](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/job-configuration/job-configuration.md)
* [Job Configuration for CDC](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/job-configuration/job-configuration-for-cdc.md)

### Review and run the job&#x20;

The Wizard auto-generates the SQL code for creating your job, and sub-jobs where applicable. You can open this code in a query window, and enhance the job using advanced features.&#x20;

* [Review and Run Job](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/review-and-run-job.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://upsolver.gitbook.io/content/quickstarts-1/data-ingestion-wizard/using-the-wizard.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.