Execute SQL Query
Run a SQL query on Amazon Redshift and retrieve results.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.EXECUTE_SQL_QUERY])
Create Table
Create a new table in Amazon Redshift with specified schema.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_TABLE])
Insert Data
Insert new data rows into an existing Redshift table.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.INSERT_DATA])
Delete Data
Delete data from a Redshift table based on specified conditions.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.DELETE_DATA])
Update Data
Update existing data in a Redshift table.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.UPDATE_DATA])
Create View
Create a new view in Amazon Redshift based on a SQL query.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_VIEW])
Drop Table
Remove an existing table from Amazon Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.DROP_TABLE])
Truncate Table
Remove all rows from a specified table in Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.TRUNCATE_TABLE])
Alter Table
Modify the structure of an existing table in Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.ALTER_TABLE])
Create User
Create a new user account in Amazon Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_USER])
Grant Permissions
Grant specific permissions to a user or role in Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.GRANT_PERMISSIONS])
Revoke Permissions
Revoke previously granted permissions from a user or role.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.REVOKE_PERMISSIONS])
Create Schema
Create a new schema in Amazon Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_SCHEMA])
Vacuum Table
Perform vacuum operation on a table to reclaim space and sort data.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.VACUUM_TABLE])
Analyze Table
Update table statistics for query optimization in Redshift.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.ANALYZE_TABLE])
Copy Data From S3
Load data into a Redshift table from an S3 bucket.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.COPY_DATA_FROM_S3])
Unload Data To S3
Export data from a Redshift table to an S3 bucket.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.UNLOAD_DATA_TO_S3])
Create Snapshot
Create a manual snapshot of the Redshift cluster.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CREATE_SNAPSHOT])
Restore From Snapshot
Restore a Redshift cluster from a previously created snapshot.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.RESTORE_FROM_SNAPSHOT])
Resize Cluster
Change the node type or number of nodes in a Redshift cluster.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.RESIZE_CLUSTER])
New Table Created
Triggered when a new table is created in the Redshift cluster.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.NEW_TABLE_CREATED])
Query Completed
Triggered when a SQL query execution is completed.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.QUERY_COMPLETED])
Data Load Completed
Triggered when a data load operation (e.g., COPY command) is finished.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.DATA_LOAD_COMPLETED])
Cluster Status Changed
Triggered when the Redshift cluster status changes (e.g., available, modifying).
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.CLUSTER_STATUS_CHANGED])
Storage Threshold Exceeded
Triggered when cluster storage usage exceeds a specified threshold.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.STORAGE_THRESHOLD_EXCEEDED])
Long Running Query Detected
Triggered when a query runs longer than a specified duration.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.LONG_RUNNING_QUERY_DETECTED])
User Login
Triggered when a user successfully logs into the Redshift cluster.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.USER_LOGIN])
Failed Login Attempt
Triggered when there's a failed login attempt to the Redshift cluster.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.FAILED_LOGIN_ATTEMPT])
Snapshot Created
Triggered when a new snapshot of the Redshift cluster is created.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.SNAPSHOT_CREATED])
Maintenance Window Started
Triggered when the scheduled maintenance window for the cluster begins.
from composio_openai import ComposioToolSet, Action
tool_set = ComposioToolSet()
tools = tool_set.get_tools(actions=[Action.MAINTENANCE_WINDOW_STARTED])