The Search Optimization Service significantly improves the performance of selective point lookup queries on tables by creating and maintaining a persistent data structure called a search access path, which allows some micro-partitions to be skipped when scanning the table

In Snowflake, theDOUBLEdata type is used for floating-point numbers and can represent a wide range of values without losing precision. This data type is ideal for storing numerical values that require decimal precision.
Define the Column:When creating a table, specify the column with theDOUBLEdata type to store floating- point numbers.
CREATE TABLE example_table (
id INTEGER,
value DOUBLE
);
Insert Data:Insert floating-point numbers into theDOUBLEcolumn.
INSERT INTO example_table (id, value) VALUES (1, 123.456);
References:
Snowflake Documentation: Data Types
Snowflake Documentation: Numeric Data Types

To grant a role the privilege to select data from all current and future tables in a schema, two separate commands are needed. The first command grants the SELECT privilege on all existing tables within the schema, and the second command grants the SELECT privilege on all tables that will be created in the future within the same schema.