Last active
March 19, 2024 14:30
-
-
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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