Skip to content

Instantly share code, notes, and snippets.

@dylanholmes
Last active March 19, 2024 14:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dylanholmes/7b1712ed95e1b8fa822b81f66ca4ce9c to your computer and use it in GitHub Desktop.
Save dylanholmes/7b1712ed95e1b8fa822b81f66ca4ce9c to your computer and use it in GitHub Desktop.
https://docs.griptape.ai/latest/griptape-framework/drivers/sql-drivers/ After - Edit MarkdownifyWebScraperDriver #695
[Skip to content](#overview)
[Star and contribute](https://github.com/griptape-ai/griptape) to Griptape on GitHub!
[![logo](../../../assets/img/griptape-mark-square-light.svg)](../../.. "Griptape Docs")
Griptape Docs
SQL Drivers
Type to start searching
* [Home](../../..)
* [Cloud](../../../griptape-cloud/)
* [Framework](../../)
* [Tools](../../../griptape-tools/)
* [Recipes](../../../examples/)
* [Reference Guide](../../../reference/SUMMARY/)
* [Trade School](https://learn.griptape.ai)
[![logo](../../../assets/img/griptape-mark-square-light.svg)](../../.. "Griptape Docs")
Griptape Docs
* Home
Home
+ [Overview](../../..)
+ [Contributing](../../../contributing/)
* Cloud
Cloud
+ [Overview](../../../griptape-cloud/)
+ [Developer Preview FAQ](../../../griptape-cloud/dev-preview-faq/)
+ Getting Started
Getting Started
- [Quick Start](../../../griptape-cloud/getting-started/)
- [Quick Start (CLI)](../../../griptape-cloud/getting-started/quickstart-cli/)
- [Quick Start (Sample Templates)](../../../griptape-cloud/getting-started/quickstart-samples/)
- [Quick Start (From Scratch)](../../../griptape-cloud/getting-started/quickstart-scratch/)
+ Cloud User Guide
Cloud User Guide
- [Overview](../../../griptape-cloud/cloud-user-guide/)
- [API Keys](../../../griptape-cloud/cloud-user-guide/api-keys/)
+ Griptape CLI
Griptape CLI
- [Installation](../../../griptape-cloud/cli/)
- [Configuration](../../../griptape-cloud/cli/configure/)
+ Cloud API
Cloud API
- [API Reference](../../../griptape-cloud/api/api-reference/)
+ [Terms of Service](../../../griptape-cloud/terms-of-service/)
* Framework
Framework
+ [Overview](../../)
+ Structures
Structures
- [Agents](../../structures/agents/)
- [Pipelines](../../structures/pipelines/)
- [Workflows](../../structures/workflows/)
- [Tasks](../../structures/tasks/)
- [Task Memory](../../structures/task-memory/)
- [Conversation Memory](../../structures/conversation-memory/)
- [Rulesets](../../structures/rulesets/)
- [Config](../../structures/config/)
+ Tools
Tools
- [Overview](../../tools/)
- [Building Custom Tools](../../../griptape-tools/custom-tools/)
+ Engines
Engines
- [Query Engines](../../engines/query-engines/)
- [Extraction Engines](../../engines/extraction-engines/)
- [Summary Engines](../../engines/summary-engines/)
- [Image Generation Engines](../../engines/image-generation-engines/)
- [Image Query Engines](../../engines/image-query-engines/)
+ Drivers
Drivers
- [Prompt Drivers](../prompt-drivers/)
- [Embedding Drivers](../embedding-drivers/)
- [Vector Store Drivers](../vector-store-drivers/)
- [Image Generation Drivers](../image-generation-drivers/)
- SQL Drivers
[SQL Drivers](./)
Table of contents
* [Overview](#overview)
* [SqlDriver](#sqldriver)
* [AmazonRedshiftSqlDriver](#amazonredshiftsqldriver)
* [SnowflakeSqlDriver](#snowflakesqldriver)
- [Image Query Drivers](../image-query-drivers/)
+ Data
Data
- [Overview](../../data/)
- [Artifacts](../../data/artifacts/)
- [Chunkers](../../data/chunkers/)
- [Loaders](../../data/loaders/)
+ Misc
Misc
- [Events](../../misc/events/)
- [Tokenizers](../../misc/tokenizers/)
* Tools
Tools
+ [Overview](../../../griptape-tools/)
+ Official Tools
Official Tools
- [AwsIamClient](../../../griptape-tools/official-tools/aws-iam-client/)
- [AwsS3Client](../../../griptape-tools/official-tools/aws-s3-client/)
- [Calculator](../../../griptape-tools/official-tools/calculator/)
- [Computer](../../../griptape-tools/official-tools/computer/)
- [DateTime](../../../griptape-tools/official-tools/date-time/)
- [EmailClient](../../../griptape-tools/official-tools/email-client/)
- [FileManager](../../../griptape-tools/official-tools/file-manager/)
- [GoogleCalendarClient](../../../griptape-tools/official-tools/google-cal-client/)
- [GoogleGmailClient](../../../griptape-tools/official-tools/google-gmail-client/)
- [GoogleDriveClient](../../../griptape-tools/official-tools/google-drive-client/)
- [GoogleDocsClient](../../../griptape-tools/official-tools/google-docs-client/)
- [OpenWeatherClient](../../../griptape-tools/official-tools/openweather-client/)
- [RestApiClient](../../../griptape-tools/official-tools/rest-api-client/)
- [SqlClient](../../../griptape-tools/official-tools/sql-client/)
- [TaskMemoryClient](../../../griptape-tools/official-tools/task-memory-client/)
- [VectorStoreClient](../../../griptape-tools/official-tools/vector-store-client/)
- [WebScraper](../../../griptape-tools/official-tools/web-scraper/)
- [WebSearch](../../../griptape-tools/official-tools/web-search/)
- [PromptImageGenerationClient](../../../griptape-tools/official-tools/prompt-image-generation-client/)
- [VariationImageGenerationClient](../../../griptape-tools/official-tools/variation-image-generation-client/)
- [InpaintingImageGenerationClient](../../../griptape-tools/official-tools/inpainting-image-generation-client/)
- [OutpaintingImageGenerationClient](../../../griptape-tools/official-tools/outpainting-image-generation-client/)
- [ImageQueryClient](../../../griptape-tools/official-tools/image-query-client/)
+ Custom Tools
Custom Tools
- [Building Custom Tools](../../../griptape-tools/custom-tools/)
* Recipes
Recipes
+ [Overview](../../../examples/)
+ Agents
Agents
- [Talk to Redshift](../../../examples/talk-to-redshift/)
- [Talk to a Webpage](../../../examples/talk-to-a-webpage/)
- [Talk to a PDF](../../../examples/talk-to-a-pdf/)
- [Shared Memory Between Agents](../../../examples/multiple-agent-shared-memory/)
+ Data
Data
- [Load and Query Pinecone](../../../examples/load-and-query-pinecone/)
- [Load and Query Marqo](../../../examples/load-query-and-chat-marqo/)
- [Query a Webpage](../../../examples/query-webpage/)
* [Reference Guide](../../../reference/SUMMARY/)
Reference Guide
+ [Griptape](../../../reference/griptape/)
Griptape
- [Artifacts](../../../reference/griptape/artifacts/)
Artifacts
* [Base artifact](../../../reference/griptape/artifacts/base_artifact/)
* [Blob artifact](../../../reference/griptape/artifacts/blob_artifact/)
* [Csv row artifact](../../../reference/griptape/artifacts/csv_row_artifact/)
* [Error artifact](../../../reference/griptape/artifacts/error_artifact/)
* [Image artifact](../../../reference/griptape/artifacts/image_artifact/)
* [Info artifact](../../../reference/griptape/artifacts/info_artifact/)
* [List artifact](../../../reference/griptape/artifacts/list_artifact/)
* [Text artifact](../../../reference/griptape/artifacts/text_artifact/)
- [Chunkers](../../../reference/griptape/chunkers/)
Chunkers
* [Base chunker](../../../reference/griptape/chunkers/base_chunker/)
* [Chunk separator](../../../reference/griptape/chunkers/chunk_separator/)
* [Markdown chunker](../../../reference/griptape/chunkers/markdown_chunker/)
* [Pdf chunker](../../../reference/griptape/chunkers/pdf_chunker/)
* [Text chunker](../../../reference/griptape/chunkers/text_chunker/)
- [Config](../../../reference/griptape/config/)
Config
* [Amazon bedrock structure config](../../../reference/griptape/config/amazon_bedrock_structure_config/)
* [Base config](../../../reference/griptape/config/base_config/)
* [Base structure config](../../../reference/griptape/config/base_structure_config/)
* [Openai structure config](../../../reference/griptape/config/openai_structure_config/)
* [Structure config](../../../reference/griptape/config/structure_config/)
* [Structure global drivers config](../../../reference/griptape/config/structure_global_drivers_config/)
* [Structure task memory config](../../../reference/griptape/config/structure_task_memory_config/)
* [Structure task memory extraction engine config](../../../reference/griptape/config/structure_task_memory_extraction_engine_config/)
* [Structure task memory extraction engine csv config](../../../reference/griptape/config/structure_task_memory_extraction_engine_csv_config/)
* [Structure task memory extraction engine json config](../../../reference/griptape/config/structure_task_memory_extraction_engine_json_config/)
* [Structure task memory query engine config](../../../reference/griptape/config/structure_task_memory_query_engine_config/)
* [Structure task memory summary engine config](../../../reference/griptape/config/structure_task_memory_summary_engine_config/)
- [Drivers](../../../reference/griptape/drivers/)
Drivers
* [Embedding](../../../reference/griptape/drivers/embedding/)
Embedding
+ [Amazon bedrock cohere embedding driver](../../../reference/griptape/drivers/embedding/amazon_bedrock_cohere_embedding_driver/)
+ [Amazon bedrock titan embedding driver](../../../reference/griptape/drivers/embedding/amazon_bedrock_titan_embedding_driver/)
+ [Amazon sagemaker embedding driver](../../../reference/griptape/drivers/embedding/amazon_sagemaker_embedding_driver/)
+ [Azure openai embedding driver](../../../reference/griptape/drivers/embedding/azure_openai_embedding_driver/)
+ [Base embedding driver](../../../reference/griptape/drivers/embedding/base_embedding_driver/)
+ [Base multi model embedding driver](../../../reference/griptape/drivers/embedding/base_multi_model_embedding_driver/)
+ [Dummy embedding driver](../../../reference/griptape/drivers/embedding/dummy_embedding_driver/)
+ [Huggingface hub embedding driver](../../../reference/griptape/drivers/embedding/huggingface_hub_embedding_driver/)
+ [Openai embedding driver](../../../reference/griptape/drivers/embedding/openai_embedding_driver/)
* [Embedding model](../../../reference/griptape/drivers/embedding_model/)
Embedding model
+ [Base embedding model driver](../../../reference/griptape/drivers/embedding_model/base_embedding_model_driver/)
+ [Sagemaker huggingface embedding model driver](../../../reference/griptape/drivers/embedding_model/sagemaker_huggingface_embedding_model_driver/)
+ [Sagemaker tensorflow hub embedding model driver](../../../reference/griptape/drivers/embedding_model/sagemaker_tensorflow_hub_embedding_model_driver/)
* [Image generation](../../../reference/griptape/drivers/image_generation/)
Image generation
+ [Amazon bedrock image generation driver](../../../reference/griptape/drivers/image_generation/amazon_bedrock_image_generation_driver/)
+ [Azure openai image generation driver](../../../reference/griptape/drivers/image_generation/azure_openai_image_generation_driver/)
+ [Base image generation driver](../../../reference/griptape/drivers/image_generation/base_image_generation_driver/)
+ [Base multi model image generation driver](../../../reference/griptape/drivers/image_generation/base_multi_model_image_generation_driver/)
+ [Dummy image generation driver](../../../reference/griptape/drivers/image_generation/dummy_image_generation_driver/)
+ [Leonardo image generation driver](../../../reference/griptape/drivers/image_generation/leonardo_image_generation_driver/)
+ [Openai image generation driver](../../../reference/griptape/drivers/image_generation/openai_image_generation_driver/)
* [Image generation model](../../../reference/griptape/drivers/image_generation_model/)
Image generation model
+ [Base image generation model driver](../../../reference/griptape/drivers/image_generation_model/base_image_generation_model_driver/)
+ [Bedrock stable diffusion image generation model driver](../../../reference/griptape/drivers/image_generation_model/bedrock_stable_diffusion_image_generation_model_driver/)
+ [Bedrock titan image generation model driver](../../../reference/griptape/drivers/image_generation_model/bedrock_titan_image_generation_model_driver/)
* [Image query](../../../reference/griptape/drivers/image_query/)
Image query
+ [Base image query driver](../../../reference/griptape/drivers/image_query/base_image_query_driver/)
+ [Dummy image query driver](../../../reference/griptape/drivers/image_query/dummy_image_query_driver/)
+ [Openai vision image query driver](../../../reference/griptape/drivers/image_query/openai_vision_image_query_driver/)
* [Memory](../../../reference/griptape/drivers/memory/)
Memory
+ [Conversation](../../../reference/griptape/drivers/memory/conversation/)
Conversation
- [Amazon dynamodb conversation memory driver](../../../reference/griptape/drivers/memory/conversation/amazon_dynamodb_conversation_memory_driver/)
- [Base conversation memory driver](../../../reference/griptape/drivers/memory/conversation/base_conversation_memory_driver/)
- [Local conversation memory driver](../../../reference/griptape/drivers/memory/conversation/local_conversation_memory_driver/)
* [Prompt](../../../reference/griptape/drivers/prompt/)
Prompt
+ [Amazon bedrock prompt driver](../../../reference/griptape/drivers/prompt/amazon_bedrock_prompt_driver/)
+ [Amazon sagemaker prompt driver](../../../reference/griptape/drivers/prompt/amazon_sagemaker_prompt_driver/)
+ [Anthropic prompt driver](../../../reference/griptape/drivers/prompt/anthropic_prompt_driver/)
+ [Azure openai chat prompt driver](../../../reference/griptape/drivers/prompt/azure_openai_chat_prompt_driver/)
+ [Azure openai completion prompt driver](../../../reference/griptape/drivers/prompt/azure_openai_completion_prompt_driver/)
+ [Base multi model prompt driver](../../../reference/griptape/drivers/prompt/base_multi_model_prompt_driver/)
+ [Base prompt driver](../../../reference/griptape/drivers/prompt/base_prompt_driver/)
+ [Cohere prompt driver](../../../reference/griptape/drivers/prompt/cohere_prompt_driver/)
+ [Dummy prompt driver](../../../reference/griptape/drivers/prompt/dummy_prompt_driver/)
+ [Huggingface hub prompt driver](../../../reference/griptape/drivers/prompt/huggingface_hub_prompt_driver/)
+ [Huggingface pipeline prompt driver](../../../reference/griptape/drivers/prompt/huggingface_pipeline_prompt_driver/)
+ [Openai chat prompt driver](../../../reference/griptape/drivers/prompt/openai_chat_prompt_driver/)
+ [Openai completion prompt driver](../../../reference/griptape/drivers/prompt/openai_completion_prompt_driver/)
* [Prompt model](../../../reference/griptape/drivers/prompt_model/)
Prompt model
+ [Base prompt model driver](../../../reference/griptape/drivers/prompt_model/base_prompt_model_driver/)
+ [Bedrock claude prompt model driver](../../../reference/griptape/drivers/prompt_model/bedrock_claude_prompt_model_driver/)
+ [Bedrock jurassic prompt model driver](../../../reference/griptape/drivers/prompt_model/bedrock_jurassic_prompt_model_driver/)
+ [Bedrock llama prompt model driver](../../../reference/griptape/drivers/prompt_model/bedrock_llama_prompt_model_driver/)
+ [Bedrock titan prompt model driver](../../../reference/griptape/drivers/prompt_model/bedrock_titan_prompt_model_driver/)
+ [Sagemaker falcon prompt model driver](../../../reference/griptape/drivers/prompt_model/sagemaker_falcon_prompt_model_driver/)
+ [Sagemaker llama prompt model driver](../../../reference/griptape/drivers/prompt_model/sagemaker_llama_prompt_model_driver/)
* [Sql](../../../reference/griptape/drivers/sql/)
Sql
+ [Amazon redshift sql driver](../../../reference/griptape/drivers/sql/amazon_redshift_sql_driver/)
+ [Base sql driver](../../../reference/griptape/drivers/sql/base_sql_driver/)
+ [Snowflake sql driver](../../../reference/griptape/drivers/sql/snowflake_sql_driver/)
+ [Sql driver](../../../reference/griptape/drivers/sql/sql_driver/)
* [Vector](../../../reference/griptape/drivers/vector/)
Vector
+ [Amazon opensearch vector store driver](../../../reference/griptape/drivers/vector/amazon_opensearch_vector_store_driver/)
+ [Azure mongodb vector store driver](../../../reference/griptape/drivers/vector/azure_mongodb_vector_store_driver/)
+ [Base vector store driver](../../../reference/griptape/drivers/vector/base_vector_store_driver/)
+ [Dummy vector store driver](../../../reference/griptape/drivers/vector/dummy_vector_store_driver/)
+ [Local vector store driver](../../../reference/griptape/drivers/vector/local_vector_store_driver/)
+ [Marqo vector store driver](../../../reference/griptape/drivers/vector/marqo_vector_store_driver/)
+ [Mongodb atlas vector store driver](../../../reference/griptape/drivers/vector/mongodb_atlas_vector_store_driver/)
+ [Opensearch vector store driver](../../../reference/griptape/drivers/vector/opensearch_vector_store_driver/)
+ [Pgvector vector store driver](../../../reference/griptape/drivers/vector/pgvector_vector_store_driver/)
+ [Pinecone vector store driver](../../../reference/griptape/drivers/vector/pinecone_vector_store_driver/)
+ [Redis vector store driver](../../../reference/griptape/drivers/vector/redis_vector_store_driver/)
- [Engines](../../../reference/griptape/engines/)
Engines
* [Extraction](../../../reference/griptape/engines/extraction/)
Extraction
+ [Base extraction engine](../../../reference/griptape/engines/extraction/base_extraction_engine/)
+ [Csv extraction engine](../../../reference/griptape/engines/extraction/csv_extraction_engine/)
+ [Json extraction engine](../../../reference/griptape/engines/extraction/json_extraction_engine/)
* [Image](../../../reference/griptape/engines/image/)
Image
+ [Base image generation engine](../../../reference/griptape/engines/image/base_image_generation_engine/)
+ [Inpainting image generation engine](../../../reference/griptape/engines/image/inpainting_image_generation_engine/)
+ [Outpainting image generation engine](../../../reference/griptape/engines/image/outpainting_image_generation_engine/)
+ [Prompt image generation engine](../../../reference/griptape/engines/image/prompt_image_generation_engine/)
+ [Variation image generation engine](../../../reference/griptape/engines/image/variation_image_generation_engine/)
* [Image query](../../../reference/griptape/engines/image_query/)
Image query
+ [Image query engine](../../../reference/griptape/engines/image_query/image_query_engine/)
* [Query](../../../reference/griptape/engines/query/)
Query
+ [Base query engine](../../../reference/griptape/engines/query/base_query_engine/)
+ [Vector query engine](../../../reference/griptape/engines/query/vector_query_engine/)
* [Summary](../../../reference/griptape/engines/summary/)
Summary
+ [Base summary engine](../../../reference/griptape/engines/summary/base_summary_engine/)
+ [Prompt summary engine](../../../reference/griptape/engines/summary/prompt_summary_engine/)
- [Events](../../../reference/griptape/events/)
Events
* [Base action subtask event](../../../reference/griptape/events/base_action_subtask_event/)
* [Base event](../../../reference/griptape/events/base_event/)
* [Base image generation event](../../../reference/griptape/events/base_image_generation_event/)
* [Base image query event](../../../reference/griptape/events/base_image_query_event/)
* [Base prompt event](../../../reference/griptape/events/base_prompt_event/)
* [Base task event](../../../reference/griptape/events/base_task_event/)
* [Completion chunk event](../../../reference/griptape/events/completion_chunk_event/)
* [Event listener](../../../reference/griptape/events/event_listener/)
* [Finish action subtask event](../../../reference/griptape/events/finish_action_subtask_event/)
* [Finish image generation event](../../../reference/griptape/events/finish_image_generation_event/)
* [Finish image query event](../../../reference/griptape/events/finish_image_query_event/)
* [Finish prompt event](../../../reference/griptape/events/finish_prompt_event/)
* [Finish structure run event](../../../reference/griptape/events/finish_structure_run_event/)
* [Finish task event](../../../reference/griptape/events/finish_task_event/)
* [Start action subtask event](../../../reference/griptape/events/start_action_subtask_event/)
* [Start image generation event](../../../reference/griptape/events/start_image_generation_event/)
* [Start image query event](../../../reference/griptape/events/start_image_query_event/)
* [Start prompt event](../../../reference/griptape/events/start_prompt_event/)
* [Start structure run event](../../../reference/griptape/events/start_structure_run_event/)
* [Start task event](../../../reference/griptape/events/start_task_event/)
- [Exceptions](../../../reference/griptape/exceptions/)
Exceptions
* [Dummy exception](../../../reference/griptape/exceptions/dummy_exception/)
- [Loaders](../../../reference/griptape/loaders/)
Loaders
* [Base loader](../../../reference/griptape/loaders/base_loader/)
* [Base text loader](../../../reference/griptape/loaders/base_text_loader/)
* [Csv loader](../../../reference/griptape/loaders/csv_loader/)
* [Dataframe loader](../../../reference/griptape/loaders/dataframe_loader/)
* [Email loader](../../../reference/griptape/loaders/email_loader/)
* [File loader](../../../reference/griptape/loaders/file_loader/)
* [Image loader](../../../reference/griptape/loaders/image_loader/)
* [Pdf loader](../../../reference/griptape/loaders/pdf_loader/)
* [Sql loader](../../../reference/griptape/loaders/sql_loader/)
* [Text loader](../../../reference/griptape/loaders/text_loader/)
* [Web loader](../../../reference/griptape/loaders/web_loader/)
- [Memory](../../../reference/griptape/memory/)
Memory
* [Meta](../../../reference/griptape/memory/meta/)
Meta
+ [Action subtask meta entry](../../../reference/griptape/memory/meta/action_subtask_meta_entry/)
+ [Base meta entry](../../../reference/griptape/memory/meta/base_meta_entry/)
+ [Meta memory](../../../reference/griptape/memory/meta/meta_memory/)
* [Structure](../../../reference/griptape/memory/structure/)
Structure
+ [Base conversation memory](../../../reference/griptape/memory/structure/base_conversation_memory/)
+ [Conversation memory](../../../reference/griptape/memory/structure/conversation_memory/)
+ [Run](../../../reference/griptape/memory/structure/run/)
+ [Summary conversation memory](../../../reference/griptape/memory/structure/summary_conversation_memory/)
* [Task](../../../reference/griptape/memory/task/)
Task
+ [Task memory](../../../reference/griptape/memory/task/task_memory/)
+ [Storage](../../../reference/griptape/memory/task/storage/)
Storage
- [Base artifact storage](../../../reference/griptape/memory/task/storage/base_artifact_storage/)
- [Blob artifact storage](../../../reference/griptape/memory/task/storage/blob_artifact_storage/)
- [Text artifact storage](../../../reference/griptape/memory/task/storage/text_artifact_storage/)
- [Mixins](../../../reference/griptape/mixins/)
Mixins
* [Action subtask origin mixin](../../../reference/griptape/mixins/action_subtask_origin_mixin/)
* [Activity mixin](../../../reference/griptape/mixins/activity_mixin/)
* [Exponential backoff mixin](../../../reference/griptape/mixins/exponential_backoff_mixin/)
* [Image artifact file output mixin](../../../reference/griptape/mixins/image_artifact_file_output_mixin/)
* [Rule mixin](../../../reference/griptape/mixins/rule_mixin/)
* [Serializable mixin](../../../reference/griptape/mixins/serializable_mixin/)
- [Rules](../../../reference/griptape/rules/)
Rules
* [Rule](../../../reference/griptape/rules/rule/)
* [Ruleset](../../../reference/griptape/rules/ruleset/)
- [Schemas](../../../reference/griptape/schemas/)
Schemas
* [Base schema](../../../reference/griptape/schemas/base_schema/)
* [Bytes field](../../../reference/griptape/schemas/bytes_field/)
* [Polymorphic schema](../../../reference/griptape/schemas/polymorphic_schema/)
- [Structures](../../../reference/griptape/structures/)
Structures
* [Agent](../../../reference/griptape/structures/agent/)
* [Pipeline](../../../reference/griptape/structures/pipeline/)
* [Structure](../../../reference/griptape/structures/structure/)
* [Workflow](../../../reference/griptape/structures/workflow/)
- [Tasks](../../../reference/griptape/tasks/)
Tasks
* [Action subtask](../../../reference/griptape/tasks/action_subtask/)
* [Base image generation task](../../../reference/griptape/tasks/base_image_generation_task/)
* [Base task](../../../reference/griptape/tasks/base_task/)
* [Base text input task](../../../reference/griptape/tasks/base_text_input_task/)
* [Code execution task](../../../reference/griptape/tasks/code_execution_task/)
* [Csv extraction task](../../../reference/griptape/tasks/csv_extraction_task/)
* [Extraction task](../../../reference/griptape/tasks/extraction_task/)
* [Image query task](../../../reference/griptape/tasks/image_query_task/)
* [Inpainting image generation task](../../../reference/griptape/tasks/inpainting_image_generation_task/)
* [Json extraction task](../../../reference/griptape/tasks/json_extraction_task/)
* [Outpainting image generation task](../../../reference/griptape/tasks/outpainting_image_generation_task/)
* [Prompt image generation task](../../../reference/griptape/tasks/prompt_image_generation_task/)
* [Prompt task](../../../reference/griptape/tasks/prompt_task/)
* [Text query task](../../../reference/griptape/tasks/text_query_task/)
* [Text summary task](../../../reference/griptape/tasks/text_summary_task/)
* [Tool task](../../../reference/griptape/tasks/tool_task/)
* [Toolkit task](../../../reference/griptape/tasks/toolkit_task/)
* [Variation image generation task](../../../reference/griptape/tasks/variation_image_generation_task/)
- [Tokenizers](../../../reference/griptape/tokenizers/)
Tokenizers
* [Anthropic tokenizer](../../../reference/griptape/tokenizers/anthropic_tokenizer/)
* [Base tokenizer](../../../reference/griptape/tokenizers/base_tokenizer/)
* [Bedrock claude tokenizer](../../../reference/griptape/tokenizers/bedrock_claude_tokenizer/)
* [Bedrock cohere tokenizer](../../../reference/griptape/tokenizers/bedrock_cohere_tokenizer/)
* [Bedrock jurassic tokenizer](../../../reference/griptape/tokenizers/bedrock_jurassic_tokenizer/)
* [Bedrock llama tokenizer](../../../reference/griptape/tokenizers/bedrock_llama_tokenizer/)
* [Bedrock titan tokenizer](../../../reference/griptape/tokenizers/bedrock_titan_tokenizer/)
* [Cohere tokenizer](../../../reference/griptape/tokenizers/cohere_tokenizer/)
* [Dummy tokenizer](../../../reference/griptape/tokenizers/dummy_tokenizer/)
* [Huggingface tokenizer](../../../reference/griptape/tokenizers/huggingface_tokenizer/)
* [Openai tokenizer](../../../reference/griptape/tokenizers/openai_tokenizer/)
* [Simple tokenizer](../../../reference/griptape/tokenizers/simple_tokenizer/)
- [Tools](../../../reference/griptape/tools/)
Tools
* [Base aws client](../../../reference/griptape/tools/base_aws_client/)
* [Base google client](../../../reference/griptape/tools/base_google_client/)
* [Base tool](../../../reference/griptape/tools/base_tool/)
* [Aws iam client](../../../reference/griptape/tools/aws_iam_client/)
Aws iam client
+ [Tool](../../../reference/griptape/tools/aws_iam_client/tool/)
* [Aws s3 client](../../../reference/griptape/tools/aws_s3_client/)
Aws s3 client
+ [Tool](../../../reference/griptape/tools/aws_s3_client/tool/)
* [Calculator](../../../reference/griptape/tools/calculator/)
Calculator
+ [Tool](../../../reference/griptape/tools/calculator/tool/)
* [Computer](../../../reference/griptape/tools/computer/)
Computer
+ [Tool](../../../reference/griptape/tools/computer/tool/)
* [Date time](../../../reference/griptape/tools/date_time/)
Date time
+ [Tool](../../../reference/griptape/tools/date_time/tool/)
* [Email client](../../../reference/griptape/tools/email_client/)
Email client
+ [Tool](../../../reference/griptape/tools/email_client/tool/)
* [File manager](../../../reference/griptape/tools/file_manager/)
File manager
+ [Tool](../../../reference/griptape/tools/file_manager/tool/)
* [Google cal](../../../reference/griptape/tools/google_cal/)
Google cal
+ [Tool](../../../reference/griptape/tools/google_cal/tool/)
* [Google docs](../../../reference/griptape/tools/google_docs/)
Google docs
+ [Tool](../../../reference/griptape/tools/google_docs/tool/)
* [Google drive](../../../reference/griptape/tools/google_drive/)
Google drive
+ [Tool](../../../reference/griptape/tools/google_drive/tool/)
* [Google gmail](../../../reference/griptape/tools/google_gmail/)
Google gmail
+ [Tool](../../../reference/griptape/tools/google_gmail/tool/)
* [Griptape cloud knowledge base client](../../../reference/griptape/tools/griptape_cloud_knowledge_base_client/)
Griptape cloud knowledge base client
+ [Tool](../../../reference/griptape/tools/griptape_cloud_knowledge_base_client/tool/)
* [Image query client](../../../reference/griptape/tools/image_query_client/)
Image query client
+ [Tool](../../../reference/griptape/tools/image_query_client/tool/)
* [Inpainting image generation client](../../../reference/griptape/tools/inpainting_image_generation_client/)
Inpainting image generation client
+ [Tool](../../../reference/griptape/tools/inpainting_image_generation_client/tool/)
* [Openweather client](../../../reference/griptape/tools/openweather_client/)
Openweather client
+ [Tool](../../../reference/griptape/tools/openweather_client/tool/)
* [Outpainting image generation client](../../../reference/griptape/tools/outpainting_image_generation_client/)
Outpainting image generation client
+ [Tool](../../../reference/griptape/tools/outpainting_image_generation_client/tool/)
* [Prompt image generation client](../../../reference/griptape/tools/prompt_image_generation_client/)
Prompt image generation client
+ [Tool](../../../reference/griptape/tools/prompt_image_generation_client/tool/)
* [Rest api client](../../../reference/griptape/tools/rest_api_client/)
Rest api client
+ [Tool](../../../reference/griptape/tools/rest_api_client/tool/)
* [Sql client](../../../reference/griptape/tools/sql_client/)
Sql client
+ [Tool](../../../reference/griptape/tools/sql_client/tool/)
* [Task memory client](../../../reference/griptape/tools/task_memory_client/)
Task memory client
+ [Tool](../../../reference/griptape/tools/task_memory_client/tool/)
* [Variation image generation client](../../../reference/griptape/tools/variation_image_generation_client/)
Variation image generation client
+ [Tool](../../../reference/griptape/tools/variation_image_generation_client/tool/)
* [Vector store client](../../../reference/griptape/tools/vector_store_client/)
Vector store client
+ [Tool](../../../reference/griptape/tools/vector_store_client/tool/)
* [Web scraper](../../../reference/griptape/tools/web_scraper/)
Web scraper
+ [Tool](../../../reference/griptape/tools/web_scraper/tool/)
* [Web search](../../../reference/griptape/tools/web_search/)
Web search
+ [Tool](../../../reference/griptape/tools/web_search/tool/)
- [Utils](../../../reference/griptape/utils/)
Utils
* [Chat](../../../reference/griptape/utils/chat/)
* [Command runner](../../../reference/griptape/utils/command_runner/)
* [Constants](../../../reference/griptape/utils/constants/)
* [Conversation](../../../reference/griptape/utils/conversation/)
* [Decorators](../../../reference/griptape/utils/decorators/)
* [Dict utils](../../../reference/griptape/utils/dict_utils/)
* [Futures](../../../reference/griptape/utils/futures/)
* [Hash](../../../reference/griptape/utils/hash/)
* [Import utils](../../../reference/griptape/utils/import_utils/)
* [J2](../../../reference/griptape/utils/j2/)
* [Load artifact from memory](../../../reference/griptape/utils/load_artifact_from_memory/)
* [Manifest validator](../../../reference/griptape/utils/manifest_validator/)
* [Paths](../../../reference/griptape/utils/paths/)
* [Prompt stack](../../../reference/griptape/utils/prompt_stack/)
* [Python runner](../../../reference/griptape/utils/python_runner/)
* [Stream](../../../reference/griptape/utils/stream/)
* [Token counter](../../../reference/griptape/utils/token_counter/)
* [Trade School](https://learn.griptape.ai)
Table of contents
* [Overview](#overview)
* [SqlDriver](#sqldriver)
* [AmazonRedshiftSqlDriver](#amazonredshiftsqldriver)
* [SnowflakeSqlDriver](#snowflakesqldriver)
SQL Drivers
===========
Overview
--------
SQL drivers can be used to make SQL queries and load table schemas. They are used by the [SqlLoader](../../../reference/griptape/loaders/sql_loader/) to process data. All loaders implement the following methods:
* `execute_query()` executes a query and returns [RowResult](../../../reference/griptape/drivers/sql/base_sql_driver/#griptape.drivers.sql.base_sql_driver.BaseSqlDriver.RowResult.md)s.
* `execute_query_row()` executes a query and returns a raw result from SQL.
* `get_table_schema()` returns a table schema.
Info
More database-specific SQL drivers are coming soon.
SqlDriver
---------
This is a basic SQL loader based on [SQLAlchemy 1.x](https://docs.sqlalchemy.org/en/14/). Here is an example of how to use it:
```
from griptape.drivers import SqlDriver
driver = SqlDriver(
engine\_url="sqlite:///:memory:"
)
driver.execute\_query("select 'foo', 'bar';")
```
AmazonRedshiftSqlDriver
-----------------------
Info
This driver requires the `drivers-sql-redshift` [extra](../../#extras).
This is a SQL driver for interacting with the [Amazon Redshift Data API](https://docs.aws.amazon.com/redshift-data/latest/APIReference/Welcome.html)
to execute statements. Here is an example of how to use it for Redshift Serverless:
```
import boto3
import os
from griptape.drivers import AmazonRedshiftSqlDriver
session = boto3.Session()
driver = AmazonRedshiftSqlDriver(
database=os.getenv("REDSHIFT\_DATABASE"),
session=session,
cluster\_identifier=os.getenv('REDSHIFT\_CLUSTER\_IDENTIFIER'),
)
driver.execute\_query("select \* from people;")
```
SnowflakeSqlDriver
------------------
Info
This driver requires the `drivers-sql-snowflake` [extra](../../#extras).
This is a SQL driver based on the [Snowflake SQLAlchemy Toolkit](https://docs.snowflake.com/en/developer-guide/python-connector/sqlalchemy) which runs on top of the Snowflake Connector for Python. Here is an example of how to use it:
```
import os
import snowflake.connector
from snowflake.connector import SnowflakeConnection
from griptape.drivers import SnowflakeSqlDriver
def get\_snowflake\_connection() -> SnowflakeConnection:
return snowflake.connector.connect(
account=os.getenv('SNOWFLAKE\_ACCOUNT'),
user=os.getenv('SNOWFLAKE\_USER'),
password=os.getenv('SNOWFLAKE\_PASSWORD'),
database=os.getenv('SNOWFLAKE\_DATABASE'),
schema=os.getenv('SNOWFLAKE\_SCHEMA'),
warehouse=os.getenv('SNOWFLAKE\_WAREHOUSE')
)
driver = SnowflakeSqlDriver(connection\_func=get\_snowflake\_connection)
driver.execute\_query("select \* from people;")
```
Back to top
© Griptape, Inc.
Made with
[Material for MkDocs](https://squidfunk.github.io/mkdocs-material/)
v: latest
Versions
[latest](https://docs.griptape.ai/latest/)
[stable](https://docs.griptape.ai/stable/)
[griptape-cloud](https://docs.griptape.ai/griptape-cloud/)
[dev](https://docs.griptape.ai/dev/)
On Read the Docs
[Project Home](//readthedocs.org/projects/griptape/)
[Builds](//readthedocs.org/projects/griptape/builds/)
[Downloads](//readthedocs.org/projects/griptape/downloads/)
On GitHub
[View](https://github.com/griptape-ai/griptape-docs/blob/main/docs/)
[Edit](https://github.com/griptape-ai/griptape-docs/edit/main/docs/)
Search
---
Hosted by [Read the Docs](https://readthedocs.org)
·
[Privacy Policy](https://docs.readthedocs.io/page/privacy-policy.html)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment