Internal now works with Redshift. Connect Redshift to Internal in minutes and build apps to create, read, update, and delete data. Internal comes out of the box with everything you need to build great CRUD apps including components (e.g. tables, buttons, forms), CRUD Functions, and granular permissions.
Out of the Box Components for Redshift
Simply drag and drop any Internal component onto your Space to start building your CRUD app. Internal provides a variety of components including tables, buttons, forms, drop downs, images, CSV uploads, and more.
CRUD Functions for Redshift
As soon as you connect your Redshift, Internal will automatically generate CRUD Functions for each table in your database (List, Get, Update, Insert, and Delete functions). These Functions can be used with Internal’s components to create a CRUD app fast. No need to write any SQL. Just pick a function to display or modify data from your Redshift database.
Custom CRUD Functions for Redshift
If you want to create custom Redshift Functions (e.g. you want to join multiple tables and execute some complex SQL operation), you can use Internal’s Function Editor. Internal supports creating several different types of custom Redshift Functions.
This type of function is used to read data from your Redshift database. Enter a SQL query to create your function. When you create a Select function, it'll automatically include filtering and pagination, so you don't have to worry about it.
Insert, Update, Delete Functions
Use an Insert Function to create new records in a Redshift database and an Update Function to update records in your Redshift database. You’ll use Internal’s query builder to quickly create these custom Functions.
Raw SQL Exec
This type of function can be used to run custom insert, update, and delete queries as well as Stored Procedures in your Redshift database.
Raw SQL Query
This type of function can be used to run custom queries that return data from your Redshift database.
When you’re creating custom CRUD Functions for Redshift, you can also add SQL Parameters to create variable inputs that can be used by your CRUD app. For Redshift, you’ll use numbered parameters using the syntax $n. $1 refers to the first argument, $2 to the second, etc.
Granular Permissions for your Redshift CRUD Apps
Internal comes out of the box with field-level permissions that can be applied across all your Redshift CRUD apps. For example, if you create a CRUD app for editing your customer data, you can invite your customer support manager and allow them to view and edit all fields. You can also invite your customer support representative and allow them to view and edit a subset of the fields in your CRUD app.
More out of the box features for Redshift CRUD Apps!
Internal also comes with 2FA, SSO, environments (e.g. staging and production), usage history, and version history – so your Redshift data is protected, you can test your app, and you can revert changes as needed.