Regardless of the number of statements in a macro, Analytics Database treats it as a single request. When you run a macro, the system processes either all or none of its SQL statements. If a macro fails, the system aborts it, backs out any updates, and returns the database to its original state.