Mid CTA - inside the text of a blogpost
Change the text, link and button label in this component.
Write {{rich-mid-cta="/stylesheet"}} in any place of the body Rich text element of a blogpost to invoke this component
Change the text, link and button label in this component.
Write {{rich-mid-cta="/stylesheet"}} in any place of the body Rich text element of a blogpost to invoke this component
 |
 |
 |
|
| Snowflake | Amazon Redshift | Firebolt | |
|---|---|---|---|
| title spanning full row | |||
| Elasticity - separation of storage and compute | Yes | Redshift RA3, Spectrum only | Yes |
| Supported cloud infrastructure | AWS, Azure, Google Cloud | AWS only | AWS only |
| Tenancy - option for dedicated resources | Multi-tenant dedicated resources (Only VPS isolated) | Isolated tenant, use own VPC | Isolated tenancy Compute and storage |
| Compute - instance types | 1-128 nodes, unknown types | Any size, and types | 1-128 choice of any types |
| Data - internal/external, writable storage | External tables supported | Internal writable, external (Spectrum) | External tables (used for ingestion), supports updates |
| Security - data | Separate customer keys (only VPS is isolated tenant,Encryption at rest, RBAC | Isolated/VPC tenant for storage and compute, Encryption at rest, RBAC | Isolated tenant for storage and compute, Encryption at rest, RBAC |
| Security - network | Firewall, SSL, PrivateLink whitelist/blacklist control, isolated for VPS only | Firewall, SSL, PrivateLink whitelist/blacklist control, isolated/VPC tenancy | Firewall and WAF, SSL, PrivateLink whitelist/blacklist control, isolated tenancy |
| Redshift 1st generation |  Firebolt 3rd generation | test | |
| Supported cloud infrastructure | AWS only | AWS only | test |
| Isolated tenancy – option for dedicated resources | Isolated tenant, use own VPC | Multi-tenant dedicated resources | test |
| Compute – node types | Any size, and types | 1-128 choice of any types | test |
| Data – internal/external, writable storage | Internal writable, external (Spectrum) | External tables (used for ingestion) | test |
| Security – data | Isolated/VPC tenant for storage and compute Encryption at rest, RBAC | Dedicated resources for storage and compute Encryption at rest, RBAC | test |
| Security – network | Firewall, SSL, PrivateLink whitelist/ blacklist control, isolated/VPC tenancy | Firewall and WAF, SSL, PrivateLink whitelist/ blacklist control | |
| Scalability | |||
| Elasticity – (individual) query scalability | Manual | 1-click cluster resize of node type, number of nodes | |
| Elasticity – user (concurrent query) scalability | Autoscale up to 10 clusters, 15 queries per cluster, 50 queued queries total, max | Unlimited manual scaling | |
| Write scalability – batch | 1 master cluster | Strong. Multi-master parallel batch | |
| Write scalability – continuous | Limited (table-level locking) | Multi-master continuous writes | |
| Data scalability | Only with RA3: 128 RA3 nodes, 8PB of data. | No limit |
The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.
A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel.
COPY tournament_results
FROM
's3://firebolt-publishing-public/help_center_assets/firebolt_sample_dataset/rankings/TournamentID=1/'
LIMIT 50 OFFSET 50
WHERE $source_file_timestamp > NOW() - interval '3 YEARS';Voila!asdljqwjlkajsn
akjsdhjkashdjkashdjkas djkas djk
kajshdjkashdkjashasd
Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.
{{rich-mid-cta}}
The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.
A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel.
Voila!asdljqwjlkajsn
akjsdhjkashdjkashdjkas djkas djk
kajshdjkashdkjashasd
Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.
{{rich-mid-cta}}
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
COPY tournament_results
FROM
's3://firebolt-publishing-public/help_center_assets/firebolt_sample_dataset/rankings/TournamentID=1/'
LIMIT 50 OFFSET 50
WHERE $source_file_timestamp > NOW() - interval '3 YEARS';Bold text
Emphasis
Superscript
Subscript
Query #1
Query #2
Query #3
Query #5
Query #4
62 sec
72 sec
90 sec
60 sec
83 sec
0.16 sec
0.09 sec
1.88 sec
0.01 sec
1.6 sec
Disclaimer - This is not a global benchmark. The results are based on real world queries and run-times as reported by our users over their data cloud vendor, and their equivalent run-times over the same data in Firebolt after tuning and optimization
SELECT street, SUM(vol) AS TotalTrafficVolume
FROM nyc_traffic
GROUP BY street
ORDER BY TotalTrafficVolume DESC
LIMIT 10;